Skip to Content
0
Former Member
Apr 13, 2010 at 05:24 AM

How the trend and gap formulas are calculated ?

63 Views

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