Summary and Calculation Not including "0"
I am trying to find the total count of a summary field whenever a numbered value is entered that is not "0." For example, the column is "Acceleration Shots/Costs" and there are 10 records. 5 records have a value of "0" and 5 records have a value ranging from $1 - $50,000 depending on the record.
I need to find the total count any time a value is entered in that field higher than "$0" and then I also want to add the total value up when finding the records.
I'm on Filemaker 11.