Local member formula

[former_member243837]

I have created localmember formula in rows. Five of the rows are summed up.

However when I insert a row on the top of existing row, the formula start showing #REF error, since the formula is not automatically moved with new row numbers.

How to make sure the formula automatically moves, when the row are inserted.

Appreciate inputs.

[former_member196865]

Change the sum formula in the local member after insertion.

[Former Member]

Hi David,

I am not asking how you are changing the formula of local member. I am asking how you are inserting row in the report?

1) Are you using insert member functionality? You are inserting EPMOlapmember?

2) Using excel functionality like right click and insert row?

If you are using EPMOlapmember then use this formula for local member  "= sum(EPMALLMEMBERS)" and add local member after row axis.

If it is not useful then try to explain your requirement with example and screenshot.

Kindly refer below link for more detail.

Grand Totals and Subtotals Calculation in rows | SCN

Hope this will solve your problem.

[Former Member]

Hi,

how you are inserting row in the report? Are you using insert  member functionality or just by excel?

[former_member225135]

Hi,

Try offset function with Sum formula.

Regards,

Rahul