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

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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