Skip to Content
0

EPMSelectMultiMemberID formula Error

Oct 17, 2017 at 05:31 AM

75

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded

Basic Excel training required!

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Oct 17, 2017 at 07:56 AM
0

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

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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.

error-formula.png (37.3 kB)
error-formula.png (37.3 kB)
0

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

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

Corrected

0

Screenshot:

concat.png (16.2 kB)
0
avatar image
Former Member Oct 17, 2017 at 04:24 PM
0

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.


Show 7 Share
10 |10000 characters needed characters left characters exceeded

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?

0
Former Member
Vadim Kalinin

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


Gowtham.

0
Former Member
Former Member

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

Gowtham.

formula-001.png (31.3 kB)
0
Former Member
Vadim Kalinin

Hi Vadim,

Finally i did in this way.

Gowtham.

formula-001.png (37.4 kB)
0

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

0

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

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


0
Former Member
Vadim Kalinin

Ok Vadim.

Gowtham.

0