Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to show future 13 weeks data

Hello everyone,

I wanted to show future 13 weeks data what ever filter user selects.

Can anybody please help me in this.

Thanks

1 Solution

Accepted Solutions
Not applicable
Author

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)

View solution in original post

1 Reply
Not applicable
Author

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)