Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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.
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.
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.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |