Rounding down

[rajasan77]

Can any one of you tell me how to round the value down?
Ex:
1.56 to be rounded as 1.00
2.32 to be rounded as 2.00

 

[elsenorjose]

Floor(1.56) if they are hard coded values or Floor{table.field} for database field

 

[Madawc]

elsenorjose's solution would give you 1 and 2, but you asked for 1.00 and 2.00.

You could get these by

ToText(Truncate({your.field}, 0), 2)

I use truncate because I'm familiar with it. Floor would probably also work. Please try it and let us know.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP