Hi all,
Has anybody solved the issue in dealing with the calculation of scores (KPIs Actual v Target Performance Calculation - Achievement) where the actual and target values are a combination of negative and positve values. The SSM tool doesn't deal with a combination of negative and positive values e.g.
Actual Target Score%(ACT%TAR)
3 -2 -150
This doesn't make sense e.g. if company X wants to achieve Revenue Growth of -2 (as opposed to a previous year's value of -5) and achieve a value of 3 then they are over achieving and should get a positive score.
Please assist. Thanks in advance.
Kind Regards,
T