If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Round to nearest 100

Started by 6rottens, 14 Jul 2023 11:50:22 AM

Previous topic - Next topic

6rottens

I need to round values to the nearest 100. For example: 178,888 to 178,900 and 154,233 to 154,200. I've worked out how to get decimals to round the way I want, but not whole values. Any advice? Thank you!

6rottens

Answered my own question! Worked out that I could put -2 as the integer_expression in the Round function.