Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I give percentage format to a specific row for the below table ?
In the expression that calculates the percentage you can use Num with the formatting option like this
=Num(Count(Id)/Count(TOTAL Id),'0.0%')
Or go the number tab of the properties and select display as percentage for that expression
Thank you Piet for the prompt reply,
but actually the above expression wont work, I have already tried that with percentage format.
If we are giving percentage in Number tab in properties, it will get applied to the whole column, Here i want it in a single row.
Assuming then that Percentage,Test1... is a dimension you can use something like
If(YourDim='Percentage',Num(YourExpression,'0.0%'),YourExpression)