1 Reply Latest reply: Nov 15, 2011 9:04 AM by Sunil Chauhan RSS

    Set Analysis to sum data that falls between dates.

      The Problem:

      I am trying to create an open order book and need to be able to sum all orders that follow this rule...


      Order date <= Date & Posting date is > Date


      I currently have this expression in place but it is not giving me the required output.


      Sum({$< OrderDate={"<=$(Date)"}, PostingDate={">$(Date)"}>}NetVal)



      I get the feeling that this will break when it hits the last date available but I am not sure how to cater for this...


      any help would be appreciated.