Rounding function giving different result for similar numbers

Highlighted
Frequent Contributor

Rounding function giving different result for similar numbers

I am using rounding function to convert 3 decimal places to 2, but the function is giving different results for similar numbers.  

 

 Original NumberRound to 3Round to 2 
P131.49496$31.495$31.50 
P235.49528$35.495$35.49 This should be 35.50

Formula used for rounding to 3 - Round(n,3)

Formula used for rounding to 2 - Round(n*100)/100

 

 

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: Rounding function giving different result for similar numbers

HI @Yash1,

For rounding to 2 digits, can you try this? ROUND(n,2,UP).

Let me know if that works!

Regards,

Kavin.

Regards,
Kavin.
Highlighted
Frequent Contributor

Re: Rounding function giving different result for similar numbers

Hi Kavin,

Thanks for the reply.
Round function has been updated with one additional parameter "EXACT" , using this solved my issue.

Cheers,
Yash