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.