@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
.