2 Replies Latest reply on Dec 29, 2011 1:37 PM by CarrieB.

    Sum calculation based on results of another field

    CarrieB.

      Title

      Sum calculation based on results of another field

      Post

      I have a calculation field that looks like this:

      Sum (Field1; Field2; Field3; Field4; Field5; Field6)

      I have 6 more fields that follow these ones that are a yes/no result. So, for instance, Field1 is a number and FieldA is a yes/no result, Field2 is a number and FieldB is a yes/no result, etc., etc.

      I would like the Sum calculation to only include the field if the related field has a yes result.

      Can anyone help me out?

      Many many thanks in advance!!

      Carrie