Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !!
[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?
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 ?
Would you be able share few rows of data to see what exactly you are trying to do with the logic above?
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