How to restrict values to 2 decimal points without rounding it off?

[Anonymous]

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

[sunny_talwar]

Would you be able to share a sample where you have this problem?

[Anil_Babu_Samineni]

Floor() will helps you. Can you share image?

[jothimala]

Hi!!

Try using this

num(expression,'#,##.##');

or

num(expression,'#,##.00');

[ogautier62]

Hi,

floor(0.556, 0.01) gives 0.55

what's wrong for you ?

regards