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.

       

      Thanks