Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Rounding by 5 characters when dividing

Hello, I don't know is there an issue, but I have a problem by calculating Cogs (the number must be very precise)   I have three columns: [Kiekis, vnt] - Quantity (3200) [Savikaina, EUR] - Cogs...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous,

 

Based on my test, the dividing calculation returned correct value. For your problem, I would suggest you check the actual value of [Kiekis, vnt] and [Savikaina, EUR]]. The number of decimal places setting for them would affect the dividing result.

 

Best regards,

Yuliana Gu