Skip to Content
avatar image
Former Member

Inconsistent formula in a Column (Unable to clear EPMOLAPMember function)

Hi Experts,

We have an EPM data retrieval report here that the column T is supposed to show a SUM value of the row, only cell T67 always reverts to an EPMOlapMemberO(SUM()) which cannot be changed or cleared.

in cell T67:

= EPMOlapMemberO(SUM(H67:S67),"[ACCOUNT].[H1].[120000]","120000 - Surplus","","000")

In cell T66:

=SUM(H66:S66)

In Cell T68:

=SUM(H68:S68)

Plz let me know if there is any wacapture.pngy I can replace EPMOlapMemberO formula or a way to delete the EPM expansion worksheet , I really appreciate your help!

Best Regards,

Yajing

capture.png (24.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 13, 2017 at 01:04 PM

    Please provide the report screenshot!

    Add comment
    10|10000 characters needed characters exceeded

    • First - don't use EPMRetrieveData functions on the data area of EPM report - absolutely bad practice!

      Recreate your report as normal EPM report.

      Your strange function is due to Member recognition enabled! :)

  • avatar image
    Former Member
    Mar 13, 2017 at 04:34 PM

    My member recognition has been turned off all the time. but it doesn't show any difference.

    Is there a way to just correct this specific cell instead of recreating the whole report?

    Add comment
    10|10000 characters needed characters exceeded