Percentage format help

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

I have a Measure like below

=Count(ID)/Count(Distinct ID)

Getting value as 0.44123. The Number Format is Auto.

Without changing Number Format to Percentage how to show the value as 44% in the above measure.

Please help me on this.

Thanks in advance.

[agigliotti]

you can apply the num function as below:

num( Count(ID)/Count(Distinct ID), '#,##0%' )

[priyalvp24]

Hi,

If you want '%' Symbol at the end then try this

num( Count(ID)/Count(Distinct ID), '#,##0%' )%' '

Note:There is Space BetweenSingle quotes ' '

Thanks...