3 Replies Latest reply: Sep 13, 2012 12:02 PM by Chirag Chhatralia RSS

    multiple IF conditions

    Chirag Chhatralia

      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