## Rounding function giving different result for similar numbers

Certified Master Anaplanner

## 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 Number Round to 3 Round to 2 P1 31.49496 \$31.495 \$31.50 P2 35.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

1 ACCEPTED SOLUTION

Accepted Solutions
Certified Master Anaplanner

## Re: Rounding function giving different result for similar numbers

Hi Kavin,

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

Cheers,
Yash
2 REPLIES 2
Certified Master Anaplanner

## 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.
Certified Master Anaplanner

Hi Kavin,