3 Replies Latest reply on Jan 26, 2015 7:10 AM by swillette

    Field calculation that checks to see if multiple fields have data in them.

    swillette

      Title

      Field calculation that checks to see if multiple fields have data in them.

      Post

      I need to create a calculation field that will check 5 container fields to see if they have or have not data in them, and then the calculation field give the number of how many of the container fields have data. For example if 3 fields have data, a 3 appears in the calculation field.

      An IF statement like below could be used to check one field, but I’m not sure how to check multiple fields.

      If (IsEmpty (Chart Screen Shot1 ) ; "" ; 1 )

      A Case statement doesn’t seem to work. The only thing I can think of doing is maybe a Let calculation defining variables in the calculation. Any help would be appreciated.