AnsweredAssumed Answered

Counting total fields that have a value?

Question asked by KyleCarroll on Jun 25, 2014
Latest reply on Jun 25, 2014 by philmodjunk


Counting total fields that have a value?


     How would I set up a calculated field that would display the total number of a specified field that has a value in it.

     For example: A field called "Quantity". I want a calculated field to tell me how many separate records show a quantity for that table, regardless of what the actual number is. Suppose I have 10 records. 5 of them show a quantity. The total in the calculated field should be 5, however I can only figure out a way that gives me the total value of all the fields by adding the quantities together.