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

Help with ASO MDX member formula CASE IIF

in Planning 7 comments

Hello,

My ASO member formula works correctly below:

-------------------------------------

/* Working but not complete*/

CASE WHEN IsAccType ([Account].CurrentMember, Last) AND Contains ([Period].CurrentMember,{[Feb]:[Dec]})

THEN ([Period].CurrentMember,[View].[Load]) - ([Period].CurrentMember.PrevMember,[View].[Load])

ELSE [View].[Load]

END

-------------------------------------

I would now like to layer in the additional condition if the member is also an ancestor of the Asset Account member use the THEN logic. But my attempts have not worked:

-------------------------------------

/* Validates but logic is returning the IIF FALSE for everything*/

CASE WHEN IsAccType ([Account].CurrentMember, Last) AND Contains ([Period].CurrentMember,{[Feb]:[Dec]})

THEN 

IIF(IsAncestor([Assets], [Account].CurrentMember),

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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