3 Replies Latest reply on Oct 29, 2013 7:01 AM by Greg Cowart

    Help counting results within a given range

    Greg Cowart

      Hello,

       

      I'm looking for some help in finding the number of results within a given range.  I'm using the below formula to find which days performace was between .50 and .90.  I built a table but it wont produce a total across rows because it is a calculated field and I cant seem to do a sum because it is already aggregated.

       

      IF [Calc-Service Level] >.90 THEN 0 ELSEIF [Calc-Service Level] <.50 THEN 0 ELSE 1 END

       

      Ideally what i would like to do see is a % of the days where the result was 1 so i would need to sum the results and divide by the number of days in the period.

       

      Any thoughts?

       

      Thanks,