Number formatting rounding up

[Anonymous]

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

[Michael_Tarallo]

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

[Anonymous]

Note taken.

Thanks

[Anonymous]

Anything guys?

[reddy-s]

Hi Lak,

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

Thanks,

Sangram Reddy.

[Anonymous]

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 · Accepted solution]

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]

You're a star mate, worked a treat.

[reddy-s]

Not at all.

[newb_641]

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