MROUND showing inconsistent results

peggytham
peggytham
in 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:

Best Answer

  • peggytham
    peggytham
    Answer ✓

    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

     

Answers

  • Nagaraju
    Nagaraju

    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

     

  • ankit_cheeni
    ankit_cheeni

    Hi,

    When you select a cell, Anaplan shows the exact value at the top right of your module (in front of formula tab). I think the first value would is 128249.999 and the second is 128250 and that is why first one is rounding off to a 128200. Just a hunch. Please check

     

    Edit: In second case, when the value lies exactly in the middle, Anaplan rounds up towards positive infinity and thus it rounds up to 128300

  • ankit_cheeni
    ankit_cheeni

    This might help: Precision differences and large number calculations - Anaplan Technical Documentation

Categories