Forum Discussion
Percentage symbol for Pre Calculated Measure
Hi ALL,
We have a column which has been pre caluclated in database itslef. for one code I'm getting value as 42.57. But I want to see same value as 42.57%.
When I change the foramt as Percentage, value is changing to 4257.00 % , but I don't want that to happen. How should I get my value with percentage symbol.
Could you please help me out on this, Quick reply would be really appreciable.
Thanks,
Prudviraj
Hi, In a new calculated column Divide by 100 and change the format to percentage.
Also you can do this in Query Editor.
Regards
Victor
You can divide the existing column by 100 as told by Vvelarde and use the percentage for newly calculated column or else do the same in your database and directly you can use the percentage over here.
3 Replies
Hi, In a new calculated column Divide by 100 and change the format to percentage.
Also you can do this in Query Editor.
Regards
Victor
Thank you, It worked.
You can divide the existing column by 100 as told by Vvelarde and use the percentage for newly calculated column or else do the same in your database and directly you can use the percentage over here.
