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

Adobe Summit 2023 [19th to 23rd March, Las Vegas and Virtual] | Complete AEM Session & Lab list

Help shortening row calculations


Level 1


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:

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.

1 Reply


Level 5

I would prefer any screenshots from your table.

Kind regards Mandy

The ultimate experience is back.

Join us in Vegas to build skills, learn from the world's top brands, and be inspired.

Register Now