### Title

Formatting a Field

### Post

I am running into difficulty to get a formula to work properly, please offer your wisdom to help !!!

Field Name = Total Score

Type = Calculation

The formula works fine -> Sum CS + Sum FM + Sum LM + Sum C + Sum QC + Sum F

It correctly sums up the Total Score...

However when I tried to build one more test, by doing

Case ( Sum CS + Sum FM + Sum LM + Sum C + Sum QC + Sum F ;

Score C1 = "No" ; Total Score = 0 ; )

This does not work...

What I am trying to do is, Total Score is the sum of those fields, however if the data in __Score C1__ is select as " No " then, no matter what the score of the others, Total Score should result in 0...

Could someone please offer a solution, please and thanks !!!!!!!

You need to rearrange your case function:

Case ( Score C1 = "No" ; 0 ; Sum CS + Sum FM + Sum LM + Sum C + Sum QC + Sum F )