Final calculation for questionnaire

[rkass068]

I have a built in table in my database that has a quality of life questionnaire. There are 20 questions (20 fields) and eery 5 fields is considered one group. For example group 1 will determine the QOL score for physical wellbeing. 

 

Once the patient fills out the questionnaire I want a calculation field to determine the QOL score. I can do every calculation for it on filemaker except one. Once the score is calculated, it must be divided by the number of non empty fields in each group. 

 

Foe example, the patient may fill out questions 1-3 in first section and question 5 omitting 4. Once the score is calculated it must be divided by 4 since they left question 4 blank. 

 

How will i do this since filemaker doesn't have a COUNTA function like excel?

 

Thanks!

[Raybaudi]

ValueCount ( List ( Field1 ; Field2 ; .. Field5 ) ) returns the divisor.

[rkass068]

ValueCount ( List ( Field1 ; Field2 ; .. Field5 ) ) returns the divisor.

 

 

you sir are a genius! thank you very much!