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

    Preceeding load

    Mark Graham



      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.