ignoring seletions

satishqlik — Wed, 25 Nov 2020 16:16:04 GMT

Hello Experts,

I need a clarification while calculating rolling periods.

Sum({<year=,month=,quarter=,doj={'>=$(=YearStart(Today()))<=$(=Today())'}>}sales)

year=,month=,quarter=,

-Ignores the selections for year,month,quarter and It works fine

But If use Max(doj()) instead of Today()

Sum({<year=,month=,quarter=,doj={'>=$(=YearStart(Max(doj()))<=$(=Max(doj()))'}>}sales)

It won't be ignore the selections

Note:Max(doj) and Today() both are giving same result(30May2016)

I wanted to understand why it is and

If I want ignore the selections, what should I do In the same way?

Any ideas?

Re: ignoring seletions

sunny_talwar — Mon, 30 May 2016 12:05:59 GMT

May be this:

Sum({<year=, month=, quarter=, doj={'>=$(=YearStart(Max({<year=, month=, quarter=>} doj)))<=$(=Max({<year=, month=, quarter=>} doj)))'}>} sales)