I have table where values are shown with two decimal places, i.e. 6.15%, 3.08% for each row. However when the total equals 100% it is shown as 100.00%?
How do I keep the decimal point values for the rows but remove decimal point values for the total when I have 100%? So the total should show 100% instead of 100.00%
Go to Solution.
measure = if([values]=1,format([values],"###%"),[values])
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
View solution in original post
Unfortunately that didn't work.
You can use If Statment:
measure = if([values]=100%,format([values],"###%"),[values])
Find out who won the T-Shirt Design Challenge and the top 3 finalists.
Find out more about the March 2023 update.