Formatting expression for both % and Numbers

[#1]

Hi,

I need to display both % values (to two decimal places) and whole numbers as a 'value' in my pivot.  My current expression checks what the calculation should be :

If(single_value='N',num((sum(val1)/sum(val2)*100),'#,##0%'), sum(val3))

When I try this expression the percentage value is displayed incorrectly (5,232%, 479%)

I need to display percentages as 99.99% (to two decimal places) and full values which can run into 1000's (99,999 , 139942) also to two decimal places.

I have number format settings set to 'Expression Default' (see attached image).

Many thanks for  your help,

Fiorano

[Gysbert_Wassenaar · Accepted solution]

Try If(single_value='N',num((sum(val1)/sum(val2)),'#,###.00%'), num(sum(val3),'#,###.00'))

[#3]

Excellent! Works perfectly!!!

Thank you very much for your time.!