rolling week

[#1]

My rolling 6 week  logic button has this logic='("' & concat({=$(vprevweek)} distinct WeekAndYear,'"|"') & '")'

if i click on some other button click on rolling week button it wont work if i again click it works. Any idea how to resolve this.

[SreeniJD]

Hi

Your question isn't very clear.... are you saying that after double click on button, rolling week is claculating?

pls confirm!

Sreeni

[#3]

yes ... if we double click only rolling week logic works or else with one click it does not work

[sujeetsingh]

Please come in more words.

[#5]

could you please tel me rolling 4 weeks logic, so that i can check if my logic is incorrect

[SreeniJD]

Last 4 weeks Amount...

Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=WeekStart(Max(Date), -4))<=$(=Date(Max(Date)))’}>} Amount )

[Anonymous]

this is for chart expression right? i gues he wants logic  for selecting last 4 or 6 weeks in selection box

[#8]

yes this is for select in field trigger....could you please tel me what will be logic for selection rolling 4 or 6 weeks?