Skip to main content
Question

How to use more than four decimals in a formula


Forum|alt.badge.img

I added the following formula to a GI: =[CSAnswers.Value]*[POReceiptLine.ExtCost]

The value of CSAnswers.Value for one of the records is 0.204714, and the POReceiptLine.ExtCost for that record is 11,117.76. The value I get in the cell with the formula is 2,275.805472.

The product of 0.204714*11,117.76 is 2275.96112064.

After closer examination I realized that the formula is only using the first four decimals of CSAnswers.Value. So the value in the cell with the formula is the product of 0.2047*11,117.76 which is indeed 2275.805472.

How do I get the formula to calculate the value using the additional decimals?

 

6 replies

darylbowman
Captain II
Forum|alt.badge.img+13

How about

=CDec([CSAnswers.Value])*[POReceiptLine.ExtCost]


Forum|alt.badge.img
  • Author
  • Freshman I
  • 13 replies
  • November 30, 2023

@darylbowman what does CDec do?

I added it to my formula and now I’m getting 0.0000

 

 


darylbowman
Captain II
Forum|alt.badge.img+13

CDec converts a string to a decimal. CSAnswers.Value is a string in the database:

How about:

=CDec(CStr([CSAnswers.Value]))*[POReceiptLine.ExtCost]

 


Forum|alt.badge.img
  • Author
  • Freshman I
  • 13 replies
  • November 30, 2023

@darylbowman thanks for the explanation. I tried 

=CDec(CStr([CSAnswers.Value]))*[POReceiptLine.ExtCost]

And I’m still getting 0.000.

 

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2621 replies
  • December 20, 2023

Hi @aaronsilber were you able to find a solution? Thank you!


Forum|alt.badge.img
  • Author
  • Freshman I
  • 13 replies
  • December 22, 2023

Hi @Chris Hackett thanks for checking in. Unfortunately, I was not able to solve for my use case yet.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings