Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Help shortening row calculations

Avatar

Level 1

Hello,

Just wondering if anyone knows a way that I can shorten a calculation. I am sure it is really simple but for some reason I can not figure it out.

I have a table of 5 columns

The Second row is where the user enteres # of responses in each column. they are labelled: Excellent, Good, Fair, Poor, Other.

The third row is the calculation row: I need the percentage of each of the responses in each column (i.e. the percentage of Excellent responses, the percent of Good responses, etc).

I wrote the calculation based on an example that I saw but I was wondering if it could be shortened and/or simplified? this is what I have for the caluclation:

https://docs.google.com/file/d/0ByKCnDONQ5zhMEswRG9Ibm5DTmc/edit?usp=sharing

I have to create several tables like this so it is kind of annoying to have to write it all out over and over. I also want it simplified so that if someone else has to go in and change it in the future they can figure it out easily.

0 Replies

Avatar

Level 5

I would prefer any screenshots from your table.

Kind regards Mandy