I have an EPBCS MDX Outline formula and want to perform logic to only the parent member Total Entity — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

I have an EPBCS MDX Outline formula and want to perform logic to only the parent member Total Entity

Summary:

I have an EPBCS MDX Outline formula where I want to perform logic to only the parent member 'Total Entity', yet it is applying to all embers under Total Entity as well. Is there a way to exclude? Syntax I am using is below:

CASE
WHEN IS ([Scenario].CurrentMember,[OEP_Actual])
AND IS ([Cost Center].CurrentMember,[Total Entity])
AND IS ([Item].CurrentMember,[Pillar_220])
OR IS ([Item].CurrentMember,[All Item])
OR IS ([Item].CurrentMember,[Total Item])

THEN
([Account].[OFS_Financials Accounts].[OFS_Expense Planning].[OFS_Total Expenses],[Cost Center].[OEP_Total Entity].[Total Cost Center].[COR] .[CHD_COR] .[CRO_COR_CHD].[10000941],[Pillar_220]) +

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!