Share
Report
80Problem encountered: Decimals do not calculates on Variance columns. No rounding used.
For example column B has a value of 439,786.16, and column C has a value of 533,569.33, the variance result in column D presents 93,783.00. The expected result is 93,783.17
This is a minor problem but it gets worst on other columns where we need to get the variance on costs per ton. For example:
Column E has a value of 0.27 and column F has a value of 0.14 and the variance result in column G presents 0.00. The expected result is 0.13
Any ideas on how to get the expected results?
Thanks,
Sylvie
*This post is locked for comments
All responses (
Answers (
