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]) +