Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
......,'#0%')
I don't think you will get decimals with this '###%'. For decimals you would need this: '###.#%'
......,'#0%')
this should work #,##0%
Hero!