hi team,
Im trying to add a calculated field and fetch 1 where the field "chocolate" doesnt contain texts like "Vanilla" and "Strawberry" with the below formula
IF NOT CONTAINS([chocolate], 'Vanilla') OR NOT CONTAINS([chocolate],'Strawberry')
THEN 1 ELSE NULL end
and its not working and is adding 1 to all the records instead adding 1 to only chocolates apart from vanilla and strawberry.
please help me
3 answers
Hi, Gaytri
You need use 'AND' instead of 'Or'
IF NOT CONTAINS([chocolate], 'Vanilla') And NOT CONTAINS([chocolate],'Strawberry')
THEN 1 ELSE NULL end
ZZ
