1 Reply Latest reply on Apr 12, 2013 4:01 PM by Mandy_Wiesener

    Help shortening row calculations

    Aditi208

      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.