Incorrect rounding of decimal value

[Aravinth]

Hi All,

I need to remove the decimal values without rouning the value.

current value =78.90
expected value=78

Above filed is a summary field. Any thoughts if pattern in data formating can be used?

[MFGF]

Hi,

Using a floor() function should give you the correct results.

Regards,

MF.

[Suraj]

MFGF answered what I was typing... :)
floor([data item]

[COGNOiSe administrator]

Hey, he is gooood ... ;D