MROUND showing inconsistent results

Options
peggytham
peggytham Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

Hi, I am trying to use MROUND formula to round to the nearest 100.

However, there is some inconsistency that I spotted.

 

original number * multiplier = number to round

Example 1:

peggytham_0-1652419579285.png

Example 2:

peggytham_1-1652419664084.png

Why are the output number different when the "number to round" is the same?

I want it to round to the nearest 100. If there number is just nice halfway in between, it should round up.

How should I apply the formula to round up for example 1?

 

Thanks,

Peggy

 

Tagged:

Comments

  • Nagaraju
    Nagaraju Member, ALL USERS, Partner, Certified Master Anaplanner, Certified Model Builder Posts: 5 Certified Master Anaplanner

    Hi, I think that's because the underlying number is actually "128249.99999999999" and when you round it to the nearest 100, it will give 128200 which is nearer than 128300. In the second case, there are no decimals and the nearest value would be different. Hope it helps!

     

    Nagaraju_0-1652421396687.png

     

  • peggytham
    peggytham Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor

    Thanks for the quick reply both! But isn't 225,000 * 0.57 a perfect whole number of 128,250? Why is it not a whole number in anaplan? 😕

    Anyway I found the solution to just apply a ROUND formula first before MROUND so that solves it now.

    peggytham_0-1652421792591.png

     

Categories