6 Replies Latest reply: Nov 9, 2011 7:07 AM by philipe RSS

    Set Analysis - Select dates less than date in selection

      Hi QV Community,

       

      I have a problem with creating a calculation that sums quantites for a date range prior to the date selected. See attached qvw-file. i just can't get the set analysis right.

       

      That is, i have a column that should sum the transaction quantities for all dates prior to the selected date (date selected by user in the dale list box).

      This way, i will be able to get the inventory quantity at any day in history.

       

      Any help is much appreciated.

       

      Thanks,

       

      Philip