Number formatting in Text Object

[tsoley9262]

I am using an expression in a text object that looks like this ...=Count([CAV CS Domain])/Count([CAV3 CS Domain]) and they number looks like 0.72988505747126 but I want to see it in a percentage, any help would be appreciated

[TimvB · Accepted solution]

=Num(Count([CAV CS Domain])/Count([CAV3 CS Domain]),'#,##0%')

More information on the Num() function:https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Scripting/Formatting...

Hope it helps!

[tsoley9262]

Thanks worked perfect!!