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, 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?

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I tried this and got the correct number

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft 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