I need help with the following formula
if [countdistinct_entity] = 1 AND IF Contains([receiving_entity],"X") OR contains([receiving_entity],"Y") THEN "X" ELSE "Keep" ENDIF
Solved! Go to Solution.
if [countdistinct_entity] = 1 AND REGEX_Match([receiving_entity],".*(X|Y).*") THEN "X" ELSE "Keep" ENDIF
IF [countdistinct_entity] = 1
AND
(Contains([receiving_entity],"X") OR contains([receiving_entity],"Y"))
THEN "X"
ELSE "Keep"
ENDIF
The formula doesn't seem to be working consistently. It is pulling some [Countdistinct_receiving_entity] = 3 with the receiving entity being either x or y and giving it a "X"
It shouldnt be.
Is that a "/" or a straight up and down line?
Straight up and down. Not sure what it italicizes it in the formula box. Its the key above the Enter key on the keyboard.
That was my issue thank you. Going forward where do I find the straight up and down line on my keyboard?
I had edited my comment after submitting it, but its the key above your Enter Key. Hold Shift on the \ key.