Skip to main content
H
hawkbk70
Participant
August 22, 2017
Answered

Truncating a decimal to an integer

  • August 22, 2017
  • 1 reply
  • 1103 views

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 has been closed for replies.
Correct answer EddieLotter

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

Cheers

Eddie

1 reply

EddieLotter
EddieLotterCorrect answer
Inspiring
August 22, 2017

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

Cheers

Eddie

H
hawkbk70Author
Participant
August 22, 2017

Thank you. Worked perfectly.

EddieLotter
EddieLotter
Inspiring
August 22, 2017

You're welcome.

Cheers

Eddie

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices