Rounding bug when using Round function?

timothyyeo

Hi All,

I'm trying to do a simple rounding to 2 decimal places. My formula is provided below. 

In general, the results turn out as expected, however, for the values below, it seems the algorithm is erroneous. The result I was expecting for Amount_2DecPlc is -0.01. However, The Round() function returns 0 instead. Can anyone explain why this is so, and what I can do to ensure that  -0.005 will round to -0.01?

Thanks in advance.

Rgds,

Timothy

MichalM

@timothyyeo 

The function seems to require an indication that this is a negative value. If you use the below, it should fix it.

IF [Value] < 0 THEN Round([Value], -0.01)
ELSE Round([Value], 0.01)
ENDIF