AnsweredAssumed Answered

Duplicate unstored calculation result conditional formatting

Question asked by marktrosen on Apr 5, 2017
Latest reply on Apr 5, 2017 by Jaymo

I have an unstored calculation field that is concatenating several other fields together from related tables. I'm trying to set up conditional formatting to highlight this cell when the calculated result is a duplicate of an already-existing record. I've done some research and tried self-joins, but I suspect the "unstirred" part of the calculation might be tripping me up (I can't select any other storage option because it's using related tables).

 

Any suggestions? Thank you for any help.

Outcomes