Skip to Content
avatar image
Former Member

EPMSelectMultiMemberID formula Error

Hi Experts,

We want to select multiple member id's of a dimension and then based on these ids we want to override row axis using EPMAxisoverride function.

For this I used EPMSelectMultiMemberID function to select multiple member of dimension but this is working some part. After coming the dimension members i want to concatenate the members.While concatenate the members am getting the below error. Can any one help me on this error.

Gowtham.

epmfunction.png (20.9 kB)
range.png (4.4 kB)
error.png (29.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 17, 2017 at 07:56 AM

    Sorry, but you have to correctly create concatenation formula!

    Look again on my original post: https://archive.sap.com/discussions/thread/3673612

    =IF(B2<>"";MID(B2;24;LEN(B2)-24)&IF(D3<>"";","&D3;"")

    D3 not B2!!!!

    P.S. And please correct the question tag - has to be

    EPM Add-In for Excel

    P.P.S. Corrected formula:

    =IF(B2<>"";MID(B2;24;LEN(B2)-24);"")&IF(D3<>"";","&D3;"")

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 17, 2017 at 04:24 PM

    Hi Vadim,

    Thanks for the response and i did the same what you mentioned ,but the again am getting the formula error.

    Am really confused it is working in your system but the same logic not working in my system. I don't no what mistake i did .

    Can you help me on this.

    =IF(B2<>"";MID(B2;24;LEN(B2)-24);"")&IF(D3<>"";","&D3;"")


    Best Regards,

    Gowtham.

    Add comment
    10|10000 characters needed characters exceeded