AnsweredAssumed Answered

Averaging using a summary field

Question asked by Wayne_1 on Mar 31, 2010

Title

Averaging using a summary field

Post

I am using Filemaker Pro 10 on Windows XP.

 

I have created a calculation field for determining the % spend as a function of income. The income is always known, but sometimes the spend isn't.

 

I have then created a summary field to determine the average % spend. For some reason it includes the calculation fields from records that do not have the spend entered as the information is not available.

 

All the 'help' suggests the average summary field should not include values that are empty.

 

Can anyone tell me what I am doing wrong?

Outcomes