3 Replies Latest reply: Jun 22, 2015 9:26 PM by Rob Wunderlich RSS

    Preceeding load

    Mark Graham

      Hi,

       

      I'm trying to do a preceeding load from two resident tables in the script.

       

      "SKU, Quantity"  in TableA,

      "SKU, 360 dayvel." in Table B.

      I wanna do the calculations:

       

      If((Sum([Qty On Hand])/([360-day Velocity]/52))>=0 and (Sum([Qty On Hand])/([360-day Velocity]/52))<=8 as [0-8WOH]

      Anyone can give me hints.