Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
you can apply the num function as below:
num( Count(ID)/Count(Distinct ID), '#,##0%' )
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...