EPMSelectMultiMemberID formula Error

[former_member346361]

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.

[former_member186338]

Basic Excel training required!

[former_member346361]

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.

[former_member186338]

What is your Excel formula parameter delimiter? ";" or ","?

What is the result of:

=MID(B2;24;LEN(B2)-24)

or

=MID(B2,24,LEN(B2)-24)

Do you know how to work with basic Excel formulas?

[former_member346361]

=MID(B2;24;LEN(B2)-24)

Gowtham.

[former_member346361]

Yes i did the same logic in another way but is it not dynamic. Please have a look.

Gowtham.

[former_member346361]

Hi Vadim,

Finally i did in this way.

Gowtham.

[former_member186338]

Sorry, but I recommend you to remove this "solution"... it looks like a joke 😞

[former_member186338]

P.S. In your Excel the formula delimiter is "," then:

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

[former_member346361]

Ok Vadim.

Gowtham.

[former_member186338]

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;"")

[former_member346361]

Hi Vadim,

Thanks for the help vadim, i did the same what you mentioned in the thread,

again am getting the formula error. Can you help me on this.

Used these 2 formulas.

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

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

Best Regards,

Gowtham.

[former_member186338]

Extra ';"")' required in the middle of the formula!

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

Corrected

[former_member186338]

Screenshot: