### Symptom

How to measure employee performance improvement if there are four evaluation periods: < 30 days, between 31 and 60, between 61 and 120 and over 120.

Performance could be up and down and employee may work only few periods (one or two), but how to find if there is a positive difference between first and last periods.

### Resolution

The formula to grant improvement point should start evaluating from the last period. Below is the sample formula to resolve the problem:

numbervar improved:=0;

if IsNumeric({@Under30Percent}) then

(if Isnumeric({@Over120Percent}) and ToNumber({@Over120Percent})<>0 //check if there is value for the fourth period

then

(if (tonumber({@Over120Percent})-tonumber ({@Under30Percent}))>0 //check if the fourth value higher than first

then improved :=1 else improved :=0)

else

if IsNumeric({@SixtyonetoOneTwentyPercent}) and ToNumber({@SixtyonetoOneTwentyPercent})<>0 //check if there is value for the third period

then

(if (ToNumber({@SixtyonetoOneTwentyPercent})- tonumber ({@Under30Percent}))>0 //check if the third value higher than first

then improved :=1 else improved :=0)

else

if IsNumeric ({@ThirtyonetoSixtyPercent}) and ToNumber ({@ThirtyonetoSixtyPercent})<>0 //check if there is value for the second period

then

(if (ToNumber({@ThirtyonetoSixtyPercent}) - tonumber ({@Under30Percent}))>0 //check if the second value higher than first

then

improved :=1 else improved :=0) );

improved

### Keywords

KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To