Set Analysis to sum data that falls between dates.

[#1]

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

[SunilChauhan]

use this

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

i think it will not break when you use field .and when you will use variable then it might break