Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Kumar,
Please find the attached document and let me know if you have any concerns/questions.
Thanks,
SIbin Jacob.C
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
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
Hi Kumar,
Please find the attached document and let me know if you have any concerns/questions.
Thanks,
SIbin Jacob.C