AnsweredAssumed Answered

Sum calculation based on results of another field

Question asked by CarrieB. on Dec 28, 2011
Latest reply on Dec 29, 2011 by 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

Outcomes