Question

How to use more than four decimals in a formula

  • 29 November 2023
  • 6 replies
  • 77 views
A
Rank
Userlevel 1

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
Rank
Badge +11

How about

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

Daryl ⚡Contract Acumatica Developer (MVP🏆) for hire ⏩ linkedin.com/in/darylbowman
A
Rank
Userlevel 1

@darylbowman what does CDec do?

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

 

 

darylbowman
Rank
Badge +11

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

How about:

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

 

Daryl ⚡Contract Acumatica Developer (MVP🏆) for hire ⏩ linkedin.com/in/darylbowman
A
Rank
Userlevel 1

@darylbowman thanks for the explanation. I tried 

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

And I’m still getting 0.000.

 

 

Chris Hackett
Rank
Userlevel 7
Badge

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

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
A
Rank
Userlevel 1

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

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved