Set analysis sum field between calculated years

[timmy]

Hey,

I have the following formula:

=

sum( {1<Boekingsdatum = {">39941<40178"}>} [Prorata inkomsten] )

how can i change the 39941 with a calculated number; for example max(Date)?

Regards

Timmy

[Or]

You can use formulas in your set expressions using dollar-sign expansion. The following example is from the QV documentation:

sum( {$<Year = {$(#=Only(Year)-1)}>} Sales )

returns the sales for the previous year in relation to current selection. Here, a dollar-sign expansion is used to calculate previous year.