Hi, I have two columns, "Total" and "Done". I want to calculate the Percentage, if "Total" is 4 and "Done" is 2 it gets 50%.
In the end I would like to have this in a stacked column chart.
Can anyone help?
Go to Solution.
Thanks, but I solved it with the DIVIDE() Function because it can handle Errors, such as "Divide by 0".
Percentage = DIVIDE(table[Done],table[Total],0)
View solution in original post
Hi, I have two columns "Total" and "Done". I would like to calculate the percentage, that if "Total" is 4 and "Done" is 2 it gets 50%.
Also I would like to have this into a stacked column chart. Thanks!
% Percentage=SUM(Done) / SUM(Total)
Hope this was helpful
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.