Skip to main content

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개
  1. 2019년 1월 18일 오전 10:44

    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

0/9000