I am building a scorecard where if the value of a field changes to "N/A", I need the total to be divided by a different value (ie: total value - value of field that is set to "N/A"). However, I need the formula to first check if ANY of these 7 fields has a value of N/A, then subtract the values of any fields where the condition is true, and divide the sum of the remaining values by this new "total". If none of the fields has a value of "N/A").

I have set up the fields and form this way:

I have set up the fields and form this way:

- Multiple choice text field to check for Condition, and associated fields for Value of Condition (If or Case formula, depending on # of conditions - Y/N, or Y/N/N/A)
- A "Subtotal" for groups of Values
- A Total of all Subtotals
- Missing: A % Total as described above

Tabinda Tariq

What I need is to calculate the Total Value based on the combination of any of the conditions being true.

Not sure it's even doable at this point :(

Mike

This example sets the value to 20 if Field1 is N/A and Field2 is 5, and sets the value to 30 if Field1 is N/A and Field2 is 7.

Tabinda Tariq