Truncating a decimal to an integer

[hawkbk70]

I have a calculation in Report Builder that possibly returns a value that contains a decimal. I need to truncate this value to an integer. "Floor" is not in the mathematical functions. Is there a way in Report Builder to truncate a value?

Ex: 9.86 needs to appear as 9 not rounded to 10.

[EddieLotter · Accepted solution]

Use the ColdFusion "Int()" function. See the ColdFusion function reference for details.

Cheers

Eddie

[hawkbk70]

Thank you. Worked perfectly.

[EddieLotter]

You're welcome.

Cheers

Eddie