Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Currentmember in MemberFormula doesn't work for multiple selection

Hi guys,

We have a member formula in the account dimension as follows:

Iif([OBC_ORG_HIER].CURRENTMEMBER.PROPERTIES("GR_LINE")="301370",[SC_TOTAL],SUM(DESCENDANTS([OBC_ORG_HIER].CURRENTMEMBER,10,LEAVES),Iif([OBC_ORG_HIER].CURRENTMEMBER.PROPERTIES("GR_LINE")="301370",[SC_TOTAL],0)))

Basically we look at our current selection for org_hier (entity dimension) and we look for an attribute to be equal to 301370. If that's correct, then sum all transactions for that org member. Otherwise, look at all descendents of that member and sum the value for the leaves that verify this same condition.

This works fine on reports when you bring all org units that have this attribute = 301370. But when you bring a mix of org hier members on the report that make this condition true and false.... then it crashes giving us this error:

Any help on this guys?

Regards,

Iago

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question