4 Replies Latest reply: Jun 14, 2015 12:49 PM by raj 123 RSS

    Can someone correct the code please

      Table3:

       

      LOAD SKU#, [Sum of Units packed in recent 30 days],(TODAY() - MinDate30) AS [Diff. of days in 30 days time frame];

      LOAD SKU#,Sum([Units Packed 30]) as [Sum of Units packed in recent 30 days], Min(FilteredDate30) AS MinDate30

      GROUP BY SKU#;

      LOAD SKU#, [Units Packed] AS [Units Packed 30],[Ship Date] AS FilteredDate30

      RESIDENT Table1

      WHERE [Ship Date] > TODAY()-31;

       

       

       

       

      Table4:

       

      LOAD SKU#, [Sum of Units packed in recent 30 days],[Diff. of days in 30 days time frame],([Sum of Units packed in recent 30 days]/[Diff. of days in 30 days time frame]) as [30 day velocity]

       

      GROUP BY SKU#;

      LOAD SKU#, [Sum of Units packed in recent 30 days], [Diff. of days in 30 days time frame]

      Resident Table3