Discussion board where members can get started with Qlik Sense.
How do i format this number in a pivot table to round up.
but i'm getting
Go to Solution.
Try this.This should work :-)
Ceil(sum(Sales),5) - so what this would do is round it only to multiples of 5
based on your example :
it would round 769.5 to 170
Is fullstop (.) used as thousand separator or decimal separator here?
Decimal or comma
def not full stop
Sorry, decimal separator
I mean to ask is this 445,566.900 your number or 445.566.900?
needs to be
May be this:
Ok that works, but there's a rounding issue when a number is bang on .5.
Excel correct figures...QS....No format...Floor....Round......Ceil
4 4.0 4 4 4 5
300 299.7 300 299 300 300
770 769.5 769 769 769 770
It seems like i can't use any of them to get it spot on. Maybe an if statement?
So when a number is 769.5, you want it to be 770???
Yes, but numbers are in a table so i cant use Ceil as that is turning 4.0 into 5, but it still needs to be 5.