Hi all,

I am trying to do employ the following logic:

If the currentmember product is a Line, then for all the
descendants of that current member take measure.wac% - .04

This is what I currently have in MDX

IIF([Product].currentmember is [Product].[Prod Desc Lev
5].&[Product].&[Seconds].&[Lines], [Measures].[WAC%] -
.04,0)

I'm trying to figure out how to add the Descendants of
Product to the true side of the equation.

Any help would be greatly appreciated.

Thanks,

Mark

Tr

iif (IsAncestor([Product].[Prod Desc Lev 5].&[Product].&[Seconds].&[Lines], [Product].currentmember),
[Measures].[WAC%] - .04, ...

----- Mark Frank wrote: ----

Hi all

I am trying to do employ the following logic

If the currentmember product is a Line, then for all the
descendants of that current member take measure.wac% - .0

This is what I currently have in MD

IIF([Product].currentmember is [Product].[Prod Desc Lev
5].&[Product].&[Seconds].&[Lines], [Measures].[WAC%]
.04,0

I'm trying to figure out how to add the Descendants of
Product to the true side of the equation

Any help would be greatly appreciated

Thanks

Mar

Worked like a charm!

Thanks,

Mark


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!