Skip to Content
avatar image
Former Member

Conflict between row and column Epm members

Hi guys,

I am working on a report where there are local members on rows and columns.

The column local member uses epmfullcontext to read comments.

The rows are subtotal local members which is basically sum(). While the totals are being calculated, when the two local members merge it displays :

#Error - Invalid Member Name: #Not an EPMOLAPMember formula.

How do I resolve this?

Ex:

                              Amount     Comment Read

Account 1               240               Text

Account 2               450               Text

Totallocalmember                    #Error - Invalid Member Name: #Not an EPMOLAPMember formula.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jun 01, 2015 at 02:43 PM

    Hi David,

    you could try and put an iserror around the epm formula used in columns so that the error is not shown.

    BR,

    Arnold

    Add comment
    10|10000 characters needed characters exceeded