Skip to main content
Participant
Aug 22, 2017 7:20 PM UTC
Answered

Truncating a decimal to an integer

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.

This topic is closed to new replies. Start a new post to keep the conversation going.
EddieLotter
EddieLotterCorrect answer
Inspiring
Aug 22, 2017 7:54 PM UTC

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

Cheers

Eddie

3 replies

EddieLotter
EddieLotterCorrect answer
Inspiring
Aug 22, 2017 7:54 PM UTC

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

Cheers

Eddie

Translate
hawkbk70Author
Participant
Aug 22, 2017 8:01 PM UTC

Thank you. Worked perfectly.

Translate
EddieLotter
Inspiring
Aug 22, 2017 8:03 PM UTC

You're welcome.

Cheers

Eddie

Translate