AnsweredAssumed Answered

Calculation Problem

Question asked by snkm on Apr 16, 2009
Latest reply on Apr 16, 2009 by comment_1

Title

Calculation Problem

Post

I have a field called OVERALL STATS.  To populate OVERALL STATS, fields 1 through 10 are added together and divded by 10. 

 

So what I need to to have the OVERALL STATS populate even when fields 1 through 10 don't all have data.  Let's say only 6 fields are populated.  I then need these feilds added together and divided by 6.

 

Here is my temporary solution that only works when either 9 or 10 fields are populated:

 

If ( IsEmpty ( 1 ) ;  (2 + 3 + 4 + 5 + 6 + 7 + 8 + 9 + 10)/9 ;  (1+ 2 + 3 + 4 + 5 + 6 + 7 + 8 + 9 + 10)/10)

 

I can do this in excel by dividing by counta, but don't know how to do it filemaker.  If anyone knows, please help.

 

 

Outcomes