Hi,
I have a Search in which I want to label the records with a even id as Yes and odd as No.
I am currently using a formula text in the search:
CASE WHEN {entityid} = '1090056' THEN ‘Yes’ ELSE ‘No’ END
I want to replace that '1090056' with even so the formula would look like:
CASE WHEN {entityid} = even THEN ‘Yes’ ELSE ‘No’ END
Can you help me with what the formula should exactly by like?
Thanks!