4 Replies Latest reply on Mar 16, 2016 6:37 PM by Stephen Crocker

    3 condition KPI calculation help needed

    Stephen Crocker

      I need to figure out how to get a KPI of a 1, 2, or 0   so here is a sampling of results.  the query pulls in people with region and I'm using number or records to figure this out.


      Region       Sum of Individuals            KPI

      Central          1022                               ??   '


      Calculated Field.


      If rgn_code = 'Central' and [Number of Records] > 1112 then 2 elseif rgn_code = 'Central' and [Number of Records] < 999  then 0 else 1 end.


      This is an example.  I have 9 total regions to work into this.  the calculation is not working my sum total is 1022 so the kpi should be a 1 because it's less than 1112 and greater than 999.


      Any help would be greatly appreciated.  I'm trying to figure out 3 conditional calculations based on 2 fields.