3 Replies Latest reply: Feb 10, 2017 7:35 AM by Vineeth Pujari RSS

    Combining values in load script

    Mike Slottje

      Hi guys,

       

      in my loading script I want to create a field which measures our orders in portfolio.

      Therefore, I want to distinguish our confirmed orders from our orders in process.

      The orders in proces can be recognized by their "Extra Status".

      To combine these different statuses, I tried the following script which didn't worked as I hoped for.

      Concatenate

      Load *,

      "Outstanding Quantity" * [Unit Price] - [Invoice Discount Amount] - [Invoice Line Discount Amount] as [Nett Amount Order Portfolio],

      'Order Portfolio' as [Scenario]

      Resident Orders

      WHERE "Extra Status" = 5 AND Status = 1;

       

       

      Concatenate

      Load *,

      "Outstanding Quantity" * [Unit Price] - [Invoice Discount Amount] - [Invoice Line Discount Amount] as [In Process Order Portfolio],

      'Order in process Portfolio' as [Scenario]

      Resident Orders

      WHERE "Extra Status" = ('1,4,6,7,8') AND Status = 1;

       

      I'm sure you guys can help me out with this one!:)

       

      Thanks a lot!

      Mike