@Notin

@NOTIN returns members that are in one expression, but not in another other expression. In other words, @NOTIN returns what is not common between the expressions.

DTP Type:

@NOTIN can be assigned to a DTP of type member range or cross dimension.

Syntax:

@NOTIN(Argument1,Argument2)

Parameters:

Parameter	Description
Argument1	Design-time prompt, function, or members
Argument2	Design-time prompt, function, or members

Example:

[NOTIN1]=@NOTIN([MR1],[MR2])

Where:

• [NOTIN1] is a DTP of type member range that is not a checked prompt.

• [MR1] is a DTP of type member range that is a checked prompt.

• [MR2] is a DTP of type member range that is a checked prompt.

Assume that the input for MR1 is:

• Period: "Jan", "Feb", "Mar"

• Scenario: "Actual"

• Currency: "Local"

• Product: "000"

Assume that the input for MR2 is:

• Period: "Feb"

• Version: "Working"

• Currency: "Local"

• Product: "000"

In this example, [@NOTIN1] returns "Actual" because this is the only member that is not in MR2, but is in MR1.