3 Replies Latest reply: Dec 12, 2016 2:01 PM by Bill Markham RSS

    What's wrong with this expression?

    Edward Del Rincon

      Hi guys,

       

      Can someone tell me what is wrong with the expression below? Been staring at this too long, and I guess I don't see why the token doesn't match:

       

       

       

      // For invoices and removing the pallets

      sum(if(pallet<>'P' and trntype='I',

      // For invoices and replacing price with paprice

      (if(price<>0,(    //To check styles with 0 amount and not a pallet

          ((invqty)*price)*rate))),

         

          (((invqty)*pprice)

          *rate))),

         

      // For credits

      (((-(invqty)*price)*rate)

       

       

       

      Please help.

       

      Thanks,

      E