1 Reply Latest reply: Nov 24, 2014 11:04 AM by Christian Ventrigli RSS

    script

    Ramu Subramaniyan

      Hello

       

      I have table like this in my datamodel

       

      MonthTypeLEAmt
      AprilCUSTOM BROKERS    (1,670,858.99)
      AprilDUTY (20,790,770.96)
      AprilFREIGHT INBOUND    (2,243,902.26)
      AprilFREIGHT OUTBOUND (23,816,177.97)
      AprilLOGISTICS OVERHEAD            (1,048.35)
      AprilWAREHOUSING    (5,730,697.68)
      AprilTradeUnits     4,051,269.00

       

      i have to create another column in my datamodel it should be like this. please help us in scripting

       

      MonthTypeLEAmtLEUnitsAmt calculation example
      AprilCUSTOM BROKERS    (1,670,858.99)
      AprilDUTY (20,790,770.96)
      AprilFREIGHT INBOUND    (2,243,902.26)
      AprilFREIGHT OUTBOUND (23,816,177.97)
      AprilLOGISTICS OVERHEAD            (1,048.35)
      AprilWAREHOUSING    (5,730,697.68)
      AprilTradeUnits     4,051,269.00
      AprilCUSTOM BROKERS/Units -0.41=-1670858.99/4051269
      AprilDUTY/Units -5.13 (20,790,770.96)/4051269
      AprilFREIGHT INBOUND/Units -0.55 (2,243,902.26)/4,051,269.00
      AprilFREIGHT OUTBOUND/Units -5.88
      AprilLOGISTICS OVERHEAD/Units 0.00
      AprilWAREHOUSING/Units -1.41

       

      Please help us in scripting

      regards

      ramu