Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I wanted to show future 13 weeks data what ever filter user selects.
Can anybody please help me in this.
Thanks
Here is the correct answer
if(GetSelectedCount(Week_No)=0 and GetSelectedCount(Month)=0 and GetSelectedCount(Quarter)=0 and Year_No=Year(Today()),
(((sum({$<Month=,Year_No=,Week_No= {'>=$(vCWeek) <=$(vCWeek13)'}>}sold))
vCWeek = =(week(today()))
vCWeek13 = =((week(today()))+12)
Here is the correct answer
if(GetSelectedCount(Week_No)=0 and GetSelectedCount(Month)=0 and GetSelectedCount(Quarter)=0 and Year_No=Year(Today()),
(((sum({$<Month=,Year_No=,Week_No= {'>=$(vCWeek) <=$(vCWeek13)'}>}sold))
vCWeek = =(week(today()))
vCWeek13 = =((week(today()))+12)