3 Replies Latest reply on Jun 25, 2014 3:19 PM by philmodjunk

    Counting total fields that have a value?

    KyleCarroll

      Title

      Counting total fields that have a value?

      Post

           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.