# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor III

## Number formatting rounding up

Hi Guys,

How do i format this number in a pivot table to round up.

Thanks

I want:

445,567

but i'm getting

445,566,900

1 Solution

Accepted Solutions
Honored Contributor II

## Re: Number formatting rounding up

Hi Lak,

Try this.This should work :-)

Ceil(sum(Sales),5) - so what this would do is round it only to multiples of 5

it would round 769.5 to 170

17 Replies
MVP

## Re: Number formatting rounding up

Is fullstop (.) used as thousand separator or decimal separator here?

Contributor III

## Re: Number formatting rounding up

Decimal or comma

def not full stop

Contributor III

## Re: Number formatting rounding up

Sorry, decimal separator

MVP

Contributor III

445,566,900

needs to be

445,567

MVP

## Re: Number formatting rounding up

May be this:

Round(445,566,900/1000)

Contributor III

## Re: Number formatting rounding up

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?

MVP

## Re: Number formatting rounding up

So when a number is 769.5, you want it to be 770???

Contributor III

## Re: Number formatting rounding up

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.