argus2

Case function confusion

Discussion created by argus2 on Dec 20, 2015
Latest reply on Dec 20, 2015 by argus2

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."

Screen Shot 2015-12-20 at 10.56.26 AM.png

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.

Outcomes