expression

[#1]

Hi,

Got the following expression which works but comes out as 0.48% when the answer should be 48%. The two figures are 1144 and 2296.

Can anyone help?

Num(Count([Tenant_Arrears])/Count([Address]), '%##.##') 

Cheers

Chris

[#2]

Hi Chris

the best would be not to use NUM function but set your result to % in "numbers" tab

best regards

Chris

[MK_QSL · Accepted solution]

Num(Count([Tenant_Arrears])/Count([Address]), '##.##0%')

[rustyfishbones]

Hi Chris,

try like this

Num(Count([Tenant_Arrears])/Count([Address]), '#,##0%')

[#5]

you can try:

Num(Count([Tenant_Arrears])/Count([Address]), '%##.##') *100