Skip to Content
0
Former Member
Jul 06, 2009 at 11:33 AM

SSM 7 - YTD formula - weighted average over time series

56 Views

Hi all,

We have a kpi called staff cost % total cost where data is captured on a monthly basis. The final ratio value for this kpi is entered into the system i.e. staff cost amount and total cost amount is not stored in variables. We have loaded data for 2 months.

The ytd value of staff cost % total cost (at end of month 2) takes an average of month 1 and month2.

This calculation is correct but we need the YTD value to show the total staff cost amount (sum of month 1 and 2) % the sum of total staff cost amount (sum of month 1 and 2).

Is this possible and how would I go about doing this?

Thanks in advance.

T