> Heres my scenario:
>
> I have a dimension which has levels. For example, I have this:
> 7ZZZZ
> 70ZZZ
> 71ZZZ
> 72ZZZ
> 73ZZZ
>
> And I need to make a calculated cell which will zero out all the
> decendants of 7ZZZZ EXCEPT for 73ZZZ, using the calculated cell
> builder. There doesn't seem to be, at least from my looking at it, a
> function to exclude a particular descendant based on criteria other
> than duplicates or matching items. Short of creating a calculated cell
> for each descendant, except the one I don't want to include, is there a
> quick way to do this in one calculated cell? I was looking at EXCEPT,
> and DESCENDANTS and named sets even, but nothing seemed to work
> properly for what I needed this to do.
>
> Let me know
>
> Thanks!!
>
> Luis Andrei Cobo
>