Skip to Content

Local member formula

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Apr 04, 2016 at 02:27 PM

    Change the sum formula in the local member after insertion.

    Add comment
    10|10000 characters needed characters exceeded

    • 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. 😊

  • Apr 04, 2016 at 11:13 AM

    Hi,

    Try offset function with Sum formula.

    Regards,

    Rahul

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 04, 2016 at 11:58 AM

    Hi,

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

    Add comment
    10|10000 characters needed characters exceeded