Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to exclude Account# 5306510 but only for Department# CC235, otherwise I want to include it.
I only know how to exclude account numbers as seen below.
Where T$OYER >=2014 and not WildMatch(T$LEAC, '5706710','5706730','5706750','5706770','5849990','5839991','3100100','4101100','5839990','5306505','5306515','5805985','5829990','5805954','5805950','5255830');
where
not
( Account# = 5306510 and Department# = 'CC235')
or you can do thos:
Where Account# <> 5306510 or Department# <> ''CC235';
not (X and Y) becomes (not X or not Y)
Right, did I miss something by mistake or are you just explaining the logic to the OP
I was explaining to myself. I must admin I forgot the boolean algebra and I had to think a little to remember your answer and mine answer are the same.
Yes I replicated your response by twisting it around
I think you should split the rewards
I think maxgro deserves it
Thank you Massimo! This worked!