Percentage out of two collums

[MarkusHaas]

 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?

[MarkusHaas]

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!

[Anonymous]

Hello @MarkusHaas

Try this

% Percentage=SUM(Done) / SUM(Total)

Hope this was helpful

[MarkusHaas · Accepted 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)