Rounding by 5 characters when dividing

[Anonymous]

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, EUR (9889,44)
• Savikaina, vnt/EUR - Cogs for one unit

To calculate Cogs for one unit, I divide [Cogs, EUR]/[Quanity], and got - 3,09050, but in real it is 3,09045.

Some how it's round by 5 characters by dividing.

Maybe someone knows, how to get right number or have same problem that i do?

[v-yulgu-msft]

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

[Kristjan76]

I tried this and got the correct number