member formula ASO - MDX only working for first IIF
Hi in MDX (ASO member formula ) is only working for the first IIF not the others
for the below MDX, it only calculates for Actual, and Budget shows nothing
but if I move my MDX to first calculate for BUDGET, and later Actuals, then BUDGET works in Smart view, but #MISSING in ACTUAL (later part of the code)
any thing i am doing wrong?
IIF([Scenario].CurrentMember=[Actual] AND (IsUda([Account].CurrentMember, "PL") OR IsUda([Account].CurrentMember, "PLParent")) AND ([Version].CurrentMember=[ActualRate_YTD] OR [Version].CurrentMember=[ActualRate_PER])),1,
IIF([Scenario].CurrentMember=[Actual] AND (IsUda([Account].CurrentMember, "BS") OR IsUda([Account].CurrentMember, "BSParent")) AND ([Version].CurrentMember=[ActualRate_YTD] OR [Version].CurrentMember=[ActualRate_PER])),2,