Hi,
We are using SSM 7.5 SP05 and trying to understand the trend and Gap formulas using the following formulas:
1. Expenses-Score : BI_EXPENSES_TARDEV = BI_EXPENSES_ACT%BI_EXPENSES_TAR
2. Expenses-Trend: BI_EXPENSES_TRD = MOVING2(BI_EXPENSES_ACT, 1, 2)
3.Expenses-Gap Performance : BI_EXPENSES_TRDDEV =
(BI_EXPENSES_TARDEV u2013MOVING2(BI_EXPENSES_TARDEV,1,2)) %ABS(MOVING2(BI_EXPENSES_TARDEV,1,2))
We understand the score is calculated by actual as percent of target.
If someone could explain how the trend and gap are calculated and the terminology, it would be very helpful.
Thanks
Amir
Edited by: amir herrmann on Apr 13, 2010 7:25 AM