
1. Re: Formatting a Field
philmodjunk Aug 12, 2009 1:46 PM (in response to Dr.D)You need to rearrange your case function:
Case ( Score C1 = "No" ; 0 ; Sum CS + Sum FM + Sum LM + Sum C + Sum QC + Sum F )

2. Re: Formatting a Field
Dr.D Aug 13, 2009 6:46 AM (in response to Dr.D)Thanks for the suggestion, it works !!!
May I understand why the order of the case function make such a different?? Thanks for teaching me !!!

3. Re: Formatting a Field
philmodjunk Aug 13, 2009 8:28 AM (in response to Dr.D)The case function is set up so that you use pairs of parameters with the option of an "else" parameter at the end:
Case (logical expression 1 ; Calculation 1; Logical expression 2 ; Calculation 2 ; .... Else Calculation )
Case will evaluate each logical expression from left to right and return the value of the Calculation immediately after the first logical expression that evaluates to True.
In your case statement, you only have one such logical expression: Score C1 = "No" If this is true. then zero is returned. If it is not, then the second calculation (your "else" parameter) will be evaluated: Sum CS + Sum FM + Sum LM + Sum C + Sum QC + Sum F )
Since you have only one logical expression, If ( Score C1 = "No" ; 0 ; Sum CS + Sum FM + Sum LM + Sum C + Sum QC + Sum F ), will return an identical result.
For more on these functions and others, I suggest reading the help file that comes with filemaker.