4 Replies Latest reply on Jul 28, 2014 8:07 AM by philmodjunk

# Using Average in Summary

### Title

Using Average in Summary

### Post

I am collecting data from a survey.  The survey is to be reported by total participants, total female and total male.  one of the questions Is:  What your height in feet & inches.  Fields are A1f feet; and A1f inches.   I created a Calculation field called Alf the calculation is  A1f feet * 12 + A1f inches.  I am able to get the average  for Alf (total records),   But I am having difficulty getting the average height for Female and for Male.  I also have a field for gender Ala  using checkbox for female ; male.

I tried the following calculation If ( A1f feet * 12 + A1f inches = " " and A1a = "Female"; "1" ; "" )then average, but it's not working;  I also tried  another calculation field  A1f   and A1a = "Female" .

Can someone tell me the best way to get the average for female and male height, I'll also need it for weight.

Thank you

• ###### 1. Re: Using Average in Summary

Have you created a Sub-Summary part sorted on Gender?  That should work for you.  Calculations for Height would need to be converted as you have to the common factor of inches.  And the averages would need a calculation back to Feet/Inch but that is a side issue.

• ###### 2. Re: Using Average in Summary

You can also use a relationship or average inside ExecuteSQL to match to the correct subset of records to get an average.