AnsweredAssumed Answered

How to count records in a found set based on mulitple fields that have one of two values.

Question asked by jenh on Mar 10, 2010
Latest reply on Mar 11, 2010 by jenh

Title

How to count records in a found set based on mulitple fields that have one of two values.

Post

Hi.

 

I'd like to count records in a found set that have one of two values within 16 fields. 

 

That is how many records that DONT have field1...field16 that hold values of "NO ERROR" or "----".  

 

I'm currently trying to do the following calculation field

 

Let (
[
$count = 0;
$count = $count  + If (_ERROR_      ≠ "\"NO ERROR\""; 1 ;0) and
$count = $count  + If (_ERROR_     ≠ "\"----\""; 1 ;0);
$count = $count  + If (_ERROR_2_ ≠ "\"NO ERROR\""; 1 ;0) and
$count = $count  + If (_ERROR_2_ ≠ "\"----\""; 1 ;0);
$count = $count  + If (_ERROR_3_ ≠ "\"NO ERROR\""; 1 ;0) and ........ etc

 

then count it in a summary field.   The above just counts every record. 

 

Any suggestions? TY



Outcomes