Hi Amir ,
Firstly , all these three measures are calculated variables. These are dependant on the actual and target values.
Trend is calculated as the moving average of the Actuals . By moving average we mean that the values of the previous 2 months are taken and averaged .
The Gap performance is calculated as the "deviation" of the Score. Hence we use the value of the Score to calculate the gap performance. The present Score minus the average score for the previous 2 months as a percent of the average score for the previous 2 months.
I will further research into these terms and provide a more detailed explanation.
Hope this helps
Vijay
Add comment