AnsweredAssumed Answered

Formatting a Field

Question asked by Dr.D on Aug 12, 2009
Latest reply on Aug 13, 2009 by philmodjunk

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 !!!!!!!

 

 

 

 

 

 

 

 

Outcomes