Find the Percentage of the Total

Melita Clark

Hi!

I have 4 columns that I have added together in the 5th, Total column (using =sum formula). Each of the 4 columns is a single dropdown select (values: 1-10). I want to translate the Total into a percent in the Percentage column, so I thought if I took the total value and divided by 40 (the max amount) in the % column, I would get the percent, but that does not work.

Would appreciate any insights on this.

Sameer Karkhanis

Are you saying the formula in the Percentage column =Total@row/40 is not working? Make sure your Percentage column is text/number type and column is formatted to be "Percentage format" (use the formatting from the toolbar)