Less then equal to not working in set analysis

[Anonymous]

Hi Geniuses

I have a problem in set related with less then equal to

sum({$<Year = {$(vThisYear)}, Month = {"<=$(=vThisMonthText)"}>} [Product Bookings Net])

Above formula is not working when I am using less then equal to after month

require ur assistance

Thanks,

Shashnak

[CELAMBARASAN]

Hi,

If you are having date field you could make use of that.

like the one below for YTD previous year

sum({$<Year = , Month =, Date={">=$(=YearStart(AddYears(vToday,-1)))<=$(=AddYears(vToday,-1))"}>} LineSalesAmount)

Probably current year would be

sum({$<Year = , Month =, Date={">=$(=YearStart(vToday))<=$(=vToday)"}>} LineSalesAmount)

Hope that helps

Celambarasan