Problem in Master Calendar

[#1]

Hi Experts,

I am creating a Master Calendar where I am stuck on two Periods.

I have requirement that when a user selects option Current QTD vs Previous QTD, Data for change metrics compares

Current QTD and Previous QTD of same year as well as if current month is Nov and User has selected Current QTD vs Previous QTD then comparision is from Oct+Nov(Q4) and Jul+Aug(Q3) Not the full Quarter.

Similarly for STD.

It is working fine for Current & Previous Month and YTD but problem is in QTD and STD.

I am attaching my working sample QVW file with Sample Data. Kindly help.

[Gysbert_Wassenaar]

Try these:

InQuarter(Temp_Date, Today(), -0 )*-1 as PrevQTDFlag,

InQuarter(Temp_Date, Today(), -1 )*-1 as PrevQTDFlag,

YearToDate(Temp_Date, 0, Ceil(Month(Today())/6) * 6 - 5 )*-1  as CurSemesterFlag,

InQuarter(Temp_Date, Today(), -2 )*-1+InQuarter(Temp_Date, Today(), -3 )*-1 as PrevSemesterFlag

[#3]

Hi Wassenaar,

Thanks for the reply but it is not working. I am ataaching QVW file for ur refrence after incopoarting above script.

Regards,

Kumar

[sibin_jacob · Accepted solution]

Hi Kumar,

Please find the attached document and let me know if you have any concerns/questions.

Thanks,

SIbin Jacob.C