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
Solved! Go to Solution.
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
Thanks @MichalM, its working correctly now.