4 Replies Latest reply: May 9, 2012 12:24 AM by Aamir Jugnu RSS

    How to do IF THEN ELSE

    Aamir Jugnu

      Hello Everybody,

       

      Can anyone please help me to get the "COST" right ?

       

      Many Thanks In advance

       

      IF LEFT(DESC, 3) = "SRT" THEN (UNITCOST * QTYSHIPPED) * -1

       

      ELSE FCSTSALES

      AS COST;

       

       

       

      Kind Regards

      Aamir