set analysis expression

[#1]

Hello all, I'm trying to calculate the total of gross bookings, based on some selections, but can't get it right. the expression I'm using is:

sum({<fiscal = {'$(vFiscal1)'}, [week no.] <= max({{$<fiscal = {'$(vFiscal2)'}>} [week no.]})>} [Gross_bookings])

I select fiscal year equals to vFiscal1, and [week no.] smaller than or equal to the maximum [week no.] available for vFiscal2.

Have been struggling with this for hours, can anybody help me iwith this?

Thanks!!

[chiru_thota]

I guess your syntax is wrong

Try to as below .Define a variable and test it fiest.Then use it in set analysis

vWeekno=max({{$<fiscal = {'$(vFiscal2)'}>} [week no.])

sum({<fiscal = {'$(vFiscal1)'}, [week no.] ={'<=$(=$(vWeekno))'}>} [Gross_bookings])

[MK_QSL · Accepted solution]

SUM({$<fiscal = {'$(vFiscal1)'}, [week no.] = {"<=$(=Max({<fiscal = {'$(vFiscal2)'}>}[week no.]))"}>}Gross_bookings)

[#4]

Thanks Chiranjeevi, very helpful

[#5]

It worked! Thanks very much Manish