RESOLVED: Create Set based on "not in" Prompt

[adam_mc]

set([Division] ->?parm_Division?) gets me the set of Divisions selected in the Prompt.

What is the syntax to get the set of Divisions not selected.

Thanks in advance,
Adam.

[Lynn]

Try the except function. Something along the lines of this I think:

except ( [Division], set([Division] ->?parm_Division?) )

[adam_mc]

I'd actually tried that, but I kept getting myself confused between Hierarchy and Member levels.
Once I got that part clear, it works perfectly.

Thanks Much!
Adam.

[Lynn]

Great you figured it out! It is also very nice that you respond back and also update your subject to indicate resolved!! It is a little politeness that not all members bother to do.

[MFGF]

Agreed! It gets an applaud from me :)

MF.