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])
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!