4 Replies Latest reply: Jun 22, 2015 5:51 PM by Marco Wedel RSS

    preceeding load from two tables

    Mark Graham



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


      "Quantity"  in TableA,

      "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.