using the <=(smaller or equal) in set analysis when comparing 2 fields with each other

[#1]

This is the first part of my set analysis statement: Sum({<CalYearWeek <= {CurrentWeek}>} total).

I want to determine a value based on all the weeks smaller or equal than the current week i'm in. Help with syntax around the <= please.

Thankx,

Lambert.

[Miguel_Angel_Baeyens]

Hello Lambert,

Use as follows

Sum({<CalYearWeek = {'>=$(CurrentWeek)'}>} total)

having that CurrentWeek is a variable.

Hope that helps.

[#3]

thanks, that was helpfull!