Property Calculator – How to get the difference between two Multi-Select Lookup lists

In section 10.2.3 of the Property Calculator guide there's an example of combining values from two lookup properties with a simple plus notation (property1 + property2). You could try the same with a minus notation.

Thanks, I tested the minus notation as suggested.

It seems that the plus notation works for combining lookup/MSLU values, but I could not get the minus notation to remove values.

Example:

Class = Report
Allowed Classes = Review; Internal Review

First calculation:

TempAllowedClasses = {Class}+{Allowed Classes}

Result:

Report; Review; Internal Review

Then I tried:

TempAllowedClasses-{Allowed Classes}

Expected result:

Report

Actual result:

Report; Review; Internal Review

I also checked the counts, and both results contain 3 values.

So unless I missed something in the syntax, it looks like the minus notation may not support lookup/MSLU subtraction. Does that match your understanding?

Thanks, I tested the minus notation as suggested.

It seems that the plus notation works for combining lookup/MSLU values, but I could not get the minus notation to remove values.

Example:

Class = Report
Allowed Classes = Review; Internal Review

First calculation:

TempAllowedClasses = {Class}+{Allowed Classes}

Result:

Report; Review; Internal Review

Then I tried:

TempAllowedClasses-{Allowed Classes}

Expected result:

Report

Actual result:

Report; Review; Internal Review

I also checked the counts, and both results contain 3 values.

So unless I missed something in the syntax, it looks like the minus notation may not support lookup/MSLU subtraction. Does that match your understanding?