Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to restrict the values on a table upto 2 decimal points with rounding off the values.
Ex: if value = 0.556, I need the value as 0.55 and not 0.56.
I tried using the Floor(value, 0.01) function and Left(Value,4), But these functions doesn't give the desired output.
- Am also suppressing the null values that is one of the reasons am facing issue.
Can anyone please help me out here?
Thanks
Would you be able to share a sample where you have this problem?
Floor() will helps you. Can you share image?
Hi!!
Try using this
num(expression,'#,##.##');
or
num(expression,'#,##.00');
Hi,
floor(0.556, 0.01) gives 0.55
what's wrong for you ?
regards