Set Analysis parameters

[richard_chilvers]

I admit that set analysis is not my greatest strength.

I have an expression :

SUM({$<WK_BOOKED = {$(#=GetFieldSelections(WK_BOOKED))}, etc......

This works fine to select values where WK_BOOKED is the currently selected week. I'd now like to change it to select values for all weeks up to the currently selected week, ie. weeks 1-(selected week).

I have searched documentation to find how my set might be changed for this.

All help appreciated.

[jpenuliar]

Here is a sample SET code for you to wok on:

=count({<Date_In = {'>=$(=date($(vStartDate)))<=$(=date($(vEndDate)))'}>}COUNTER)

essentially, you will have a Date type field, and a Date Range saved in Variables.

Assuming, WK_BOOKED is numeric, Can you try {'<=$(#=GetFieldSelections(WK_BOOKED))'}

[richard_chilvers]

Thanks. I've had a quick go with this and it seems to work well, although I need to validate the results.

Regards