Hi,

I've been trying to get the Case function to solve a problem whereas the If function falls short. The syntax, based on the default...

Case ( test1 ; result1 {; test2 ; result2 ; ... ; defaultResult} ) has me a little stumped. If I substitute my information into this function I get an error.

Case ( TOTAL Number of Errors QC1 ≥ 0 ; 1 {; TOTAL Number of Errors QC2 ≥ 0 ; 2; TOTAL Number of Errors QC3 ≥ 0; 3} )

The error highlights the first brace ({) bracket only and says, "The specified field cannot be found."

All I wanted was to have the Quality Check field, i.e. "QC number" give a return of 1, 2 or 3, based on the content of three other fields.

Though the calc doesn't make sense in other ways, if you drop the curly braces at least it will work.

But almost always numbered fields ( xxxQC1, xxxQC2, xxxQC3) indicate a design problem.

What is the purpose of this calc and what do the numbered fields represent?

Case (

TOTAL Number of Errors QC1 ≥ 0 ; 1 ;

TOTAL Number of Errors QC2 ≥ 0 ; 2;

TOTAL Number of Errors QC3 ≥ 0; 3

)