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.
Use the ColdFusion "Int()" function. See the ColdFusion function reference for details.
Thank you. Worked perfectly.