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.