Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Felipe02
Contributor III
Contributor III

Format Numbers

Guys, how do I make qlik only round when the value is above 0.60, for example 89.60 = 90% and 89.50 = 89%?

2 Replies
LRuCelver
Partner - Creator III
Partner - Creator III

Dual(If(Number - Floor(Number) > 0.6, Ceil(Number), Floor(Number)), Number)

You might have to play around with factors of 10 a bit to get to the number of decimal places you want.

Felipe02
Contributor III
Contributor III
Author

If it has decimal places 0.60, will it round up?