1 Reply Latest reply on Aug 19, 2013 9:48 PM by Joshua Milligan

    Using conditional row count in calculations

    andy.collier

      I have a data source (from an imported Access query) where each row has a value 'pass' or 'fail' in a column named pf. This pass/fail evaluation is based on the existence of some values across multiple columns (non-numeric, mostly evaluating for existence of "NO" in question columns). I want to use the count of the rows with either value to get the number sampled and number of samples which have passed. How do I write an expression which uses this "conditional count" to return the passing rate (percentage). So, the plain English formula for this would be:

      (Count of rows with 'pass' in pf field)/(Count of rows with 'pass' + Count of rows with 'fail' in pf field)

      Some rows may have a null value in the pf field so I want to discount these entirely (though this could be selected out at a higher level in the underlying query, I believe).

       

      Thanks in advance!