14 Replies Latest reply: Jun 10, 2014 4:39 AM by Jacob Baruch RSS

    Set analysis and two dates Fields

      Hi,

       

      I've got in my module,

      the following tables:

       

      Item Table:

      Item,

      Date

       

      Sales:

      Item,

      SaleDate,

      Qty

       

      I need to calculate for each item sum(Qty) where SaleDate<= Date.

      I know set analysis back and forward but somehow i can't manage to do that.

       

      Can someone know how to solve this issue?

       

      Thnx a lot