COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: 6rottens on 14 Jul 2023 11:50:22 AM

Title: Round to nearest 100
Post by: 6rottens on 14 Jul 2023 11:50:22 AM
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!
Title: Re: Round to nearest 100
Post by: 6rottens on 14 Jul 2023 11:54:00 AM
Answered my own question! Worked out that I could put -2 as the integer_expression in the Round function.