Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Num(Count([Tenant_Arrears])/Count([Address]), '##.##0%')
Hi Chris
the best would be not to use NUM function but set your result to % in "numbers" tab
best regards
Chris
Num(Count([Tenant_Arrears])/Count([Address]), '##.##0%')
Hi Chris,
try like this
Num(Count([Tenant_Arrears])/Count([Address]), '#,##0%')
you can try:
Num(Count([Tenant_Arrears])/Count([Address]), '%##.##') *100