Except

Return to: Calculated Member Builder Function List

Finds the difference between two sets, optionally retaining duplicates.

Syntax

Except(«Set1», «Set2»[, ALL])

Remarks

Duplicates are eliminated from both sets prior to finding the difference. The optional ALL flag retains duplicates. Matching duplicates in «Set1» are eliminated and non-matching duplicates are retained.

Example

Except({Canada, BC, BC, Mexico, USA, WA}, {Canada, Mexico, CA})

returns

{BC, USA, WA}

and

Except({Canada, BC, BC, Mexico, USA, WA}, {Canada, Mexico, CA},ALL)

returns

{BC, BC, USA, WA}.