Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

18 Replies
Michael_Tarallo
Employee
Employee

Hello Lak - just FYI - please make sure you are marking these discussions as questions. I converted 2 of them for you already. That way we can make sure they are answered and marked appropriately.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
Anonymous
Not applicable
Author

Note taken.

Thanks

Anonymous
Not applicable
Author

Anything guys?

reddy-s
Master II
Master II

Hi Lak,

Just a random question, has the custom formatting option not worked?

Thanks,

Sangram Reddy.

Anonymous
Not applicable
Author

The default is turning 769.5 in 769, I need it to be 770.

These are the options that i've tried, it's either one or the other, i need the option that rounds up from .5 not .0 like Ceil.

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

Thanks

reddy-s
Master II
Master II

Hi Lak,

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

Anonymous
Not applicable
Author

You're a star mate, worked a treat.

reddy-s
Master II
Master II

Not at all.

newb_641
Contributor
Contributor

I'm also having the same issue and would like to use this resolution but where do I put this formula?