cancel
Showing results for
Search instead for
Did you mean:
Regular Visitor

Percentage out of two collums

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?

1 ACCEPTED SOLUTION
Regular Visitor

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)

3 REPLIES 3
Regular Visitor

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
Not applicable

Hello @MarkusHaas

Try this

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

Hope this was helpful

Regular Visitor

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)

Helpful resources

Announcements

Launching new user group features

Learn how to create your own user groups today!

Check it Out!

Click here to read more about the November 2021 Updates!

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors