4 Replies Latest reply on Mar 11, 2010 6:38 AM by jenh

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

    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