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
It shouldnt be.
Straight up and down. Not sure what it italicizes it in the formula box. Its the key above the Enter key on the keyboard.
if [countdistinct_entity] = 1 AND REGEX_Match([receiving_entity],".*(X|Y).*") THEN "X" ELSE "Keep" ENDIF
@Klachner
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"
Is that a "/" or a straight up and down line?
Here is a screenshot
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.
