2 Replies Latest reply: Dec 10, 2009 11:28 PM by Jean-Jacques Jesua RSS

    agg in the script

    TSWA

       

       

       

       

      What am I doing wrong?

       

      [Min PPU]:

      Load

       

       

      Family,

      Scenario

       

      ,

      [Product Name]

       

      ,

      [Total Purchase Cost]

       

      ,

      [Minimum Desired Quantity],

      If

       

      (([Product Name]=Previous([Product Name]) and Scenario = Previous(Scenario)),

      min



      ([Total Purchase Cost]/[Minimum Desired Quantity]) as [MinPPU per P]))

      resident

      Main

      order

      by

      Family

       



      ,Product,Scenario;

      Main:

      LOAD

      Supplier,

       

       

      Category,

       

       

      [Item Name],

       

       

      [Minimum Desired Quantity],

       

       

      Segment,

       

       

      Family,

       

       

      [Article number],

       

       

      [Component number],

       

       

      Scenario,

       

       

      [Product Name],

       

       

      [Article/Component],

       

       

      [Price Per Unit],

       

       

      [Historical Cost],

       

       

      [Total Historical Cost],

       

       

      [Total Purchase Cost],

       

       

      [Projected Savings],

       

       

      from

      blablabla;