3 Replies Latest reply: Mar 20, 2013 1:49 PM by Jorge Trillo Rios RSS

    load expression

    Jorge Trillo Rios

      Mornig

      I have a trouble withe a load script, maybe you can help me.

       

      i have a invoice table, each invoice has a multiple departments and i want identify the department with the higher particaption on the invoice

       

       

      INVOICEDEPARTMENTVALUE
      INVOICE1DEPARTMENT11000
      INVOICE2DEPARTMENT1500
      INVOICE1DEPARTMENT2800
      INVOICE1DEPARTMENT2400
      INVOICE1DEPARTMENT3

      12

      INVOICE2DEPARTMENT3800
      INVOICE3DEPARTMENT3200
      INVOICE4DEPARTMENT112
      INVOICE3DEPARTMENT1400
      INVOICE4DEPARTMENT3500

       

      the result must be.

      INVOICE1 = DEPARTMENT2 (800+400)

      INVOICE2=  DEPARTMENT3 (800)

      INVOICE3 = DEPARTMENT1 (400)

      INVOICE4 = DEPARTMENT3 (500)

       

      Can you help me??

       

      thanks and regards