Offset formula in sap bpc 10

[Former Member]

Hello Experts,

I'm on BPC NW 10.0 and I'm trying to create a member formula so I can calculate this KPI :

KPI1 (N) = ( KPI2 (N) + KPI2 (N-1) ) /2

Where N is the current Month, for example (06.2016) and N-1 is the same month of the last year (06.2015)

How can I achieve that ?

I tryied to use this formula ([KPI_CDG].[KPI2] + ANCESTOR([TEMPS].CURRENTMEMBER,[TEMPS].[LEVEL02]),[KPI_CDG].[KPI2]) / 2 but it's not working

Thanks

Maha

[former_member186338]

Full info required including dimension members etc....