4 Replies Latest reply: Jun 13, 2016 9:04 AM by Stefan Wühl RSS

    NOT "FIELD"

    hugo gimenez

      Hello,

      I try to write this condition :

      FIELD1 équal 'AM' and FIELD2 without 'TERA'

      So i tried to write :

      [FIELD1] = 'AM' and [FIELD2] <> 'TERA'

      But it doesn't work

      Someone know how to do a NOT in a condition ?

       

      Thanks in advance !!

        • Re: NOT "FIELD"
          Stefan Wühl

          [FIELD1] = 'AM' and NOT [FIELD2] = 'TERA'


          but I would have assumed your expression to work also. How do your field values look like and in which context are you using this expression?

            • Re: NOT "FIELD"
              hugo gimenez

              My complete sentence is

              OSW = TAI with 0 time left  - AM without TERA - MQ - CO

              So i try to write

              if([TAI Restant (h)]='0,0000' (OR Type = 'QN-AM' AND NOT [Statut Utilisateur] like '*TERA*' ) AND NOT Type like 'LP-MQ' AND NOT Type like 'CO-CO' ,'OSW')

              But it doesn't work do you have a better solution ?

                • Re: NOT "FIELD"
                  Stefan Wühl

                  I don't think the first part is correct syntax (or you may need to change the parentheses:

                   

                  if( [TAI Restant (h)]='0,0000' OR ( Type = 'QN-AM' AND NOT [Statut Utilisateur] like '*TERA*' )...


                  or maybe


                  if( ( [TAI Restant (h)]='0,0000' OR ( Type = 'QN-AM' AND NOT [Statut Utilisateur] like '*TERA*' ) )...


                  or something else

              • Re: NOT "FIELD"
                Sunny Talwar

                Would you be able share few rows of data to see what exactly you are trying to do with the logic above?