Compare Multi-Select VL Across XREF
I'm looking for a method to compare a multiple-select values list against another across a cross-reference. It could be as simple as returning a 1 if they match exactly or a 0 if there are any differences.
Is there a simple method of doing this? All testing I have tried seems to indicate the formulas require single values.
- Community Thread
- Forum Thread
- RSA Archer
- RSA Archer Suite
- values list question
Maybe create a Calculated Cross-Reference to Field Value Match on the Values List fields (Dynamic Filtering) and then create a calculated field to count (COUNTA Function) the records in the Calculated Cross-Reference. In my test (Contacts to Facilities) with multiple Values, the order of selected Values didn't have an impact either.