Question

# How to use more than four decimals in a formula

• 6 replies
• 80 views

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?

@darylbowman what does CDec do?

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

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

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

@darylbowman thanks for the explanation. I tried

``=CDec(CStr(rCSAnswers.Value]))*)POReceiptLine.ExtCost]``

And I’m still getting 0.000.

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

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