3 Replies Latest reply on Jan 18, 2019 2:52 AM by Gaytri k

    Calculated field to have values "Does not Contain" specific texts

    Gaytri k

      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