CRM44862321

[CRM44862321]

I'm trying to calculate the average of 11 rows of radio buttons with 6 columns, excluding any row containing a zero value.  The average calculation does not seem to be accurate, as it calculates all rows, even if the row has zero value.  The radio button rows are named Radio Button 1, Radio Button 2 and so forth.  Radio Button 1, column 1, has a value of 1 and on down the line to Radio Button 1, column 5, which has a value of 5.  Radio Button 1, column 6, has a value of zero.  Each column repeats this format.

How do I get them to average without counting the row with a zero value?

[George_Johnson]

You'll have to use a custom JavaScript. Here's a link to a previous thread that should get you started: Dividing fields

[CRM44862321]

Thank you for your response, however, it didn't work... I inserted the script from the link provided and no calculation appeared... any suggestions???