Number formatting

[bobbydave]

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?

[sunny_talwar]

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

[antoniotiman · Accepted solution]

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

[ramoncova06]

this should work  #,##0%

[bobbydave]

Hero!