Logic Help

[abhaysingh]

     HI all,

I have to show one kpi in which i  need to show Current Week VS Last 4 Week with next for week forecast

what would be the logic.

like i made following variables

vTodayWeek = week(today())

vLast4Week = WeekStart(vTodayWeek)-4

please help me in proper expression and with next for week logic

thanks

[jpenuliar]

have a look at below using InWeek():

Re: Last Weeks Activity

[sunny_talwar]

If I were you I would flag Current week (may be as 1) and last 4 weeks (may be as 2) and use them in my set analysis, instead of using a variable to do this.

Flagging should be easy and can be done in the Master Calendar script itself.

HTH

Best,

Sunny

[jpenuliar]

You can flag your dates instead of Variables