Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How would I put the following into my script please?
IF ( TransA = 'B' AND FreeField NOT IN ('B', 'Q', 'W', 'K') AND Checked = '1', -Quantity,
IF ( TransA = 'H' AND FreeField = 'P' AND Checked = '1', -Quantity, 0.0) As Delivery
Thanks in advance
Chirag
Thank for the help guys.
I found/used a very similar method making use of the NOT MATCH() function;
F ( TransA = 'B' AND NOT MATCH (FreeField, 'B', 'Q', 'W', 'K') AND Checked = '1', -Quantity,
IF ( TransA = 'H' AND FreeField = 'P' AND Checked = '1', -Quantity, 0.0) As Delivery
thanks again
C
Hi
Try like this,
if(TransA = 'B' and Checked = '1' , if(not mixmatch(FreeField, 'B','Q','W','K'), -Quantity),
IF ( TransA = 'H' AND FreeField = 'P' AND Checked = '1', -Quantity, 0.0)) as Delivery
Hope it helps
something lke this:
IF ( TransA = 'B' AND match(FreeField,'B','Q','W','K')=0 AND Checked = '1', -Quantity,
IF ( TransA = 'H' AND FreeField = 'P' AND Checked = '1', -Quantity, 0.0) As Delivery
Thank for the help guys.
I found/used a very similar method making use of the NOT MATCH() function;
F ( TransA = 'B' AND NOT MATCH (FreeField, 'B', 'Q', 'W', 'K') AND Checked = '1', -Quantity,
IF ( TransA = 'H' AND FreeField = 'P' AND Checked = '1', -Quantity, 0.0) As Delivery
thanks again
C