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: 
bobbydave
Creator III
Creator III

Number formatting

This is just too ridiculous to ask but ...

I have a formula

=num(AGGR(sum([Paid_claims (£)])/sum(TOTAL DISTINCT [Paid_claims (£)]), Legal_Entity), '##%')

As you can see at the end of the formula, I have formatted it to 2 figures. However, I may come across 100% which will give me the result of 1.e05 yada %

So I then change my formula to

=num(AGGR(sum([Paid_claims (£)])/sum(TOTAL DISTINCT [Paid_claims (£)]), Legal_Entity), '###%')

which means I will then get 100% as required but I will also get 25.9 or 59.5 but I don't want that decimal place.

I want whole numbers.

Any ideas?

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

4 Replies
sunny_talwar

I don't think you will get decimals with this '###%'. For decimals you would need this: '###.#%'

antoniotiman
Master III
Master III

......,'#0%')

ramoncova06
Specialist III
Specialist III

this should work  #,##0%

bobbydave
Creator III
Creator III
Author

Hero!