Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I had executed the below mentioned script for Creating Yearly Quarter. IF u load this script it will work fine the thing is for me Quater one Strat's from APR-JUN but in the below mentioned script it is taking Q1 as JAN-MAR how to solve this issue.
[Calendar]:
LOAD *
,dual('Q' & "Quarter Only" & ' ' & "Year Only",QuarterStart("Date")) as "Quarter"
;
LOAD *
,ceil("Month Only"/3) as "Quarter Only"
;
LOAD *
,date(monthstart("Date"),'MMM YYYY') as "Month"
,date(yearstart("Date"),'YYYY') as "Year"
,month("Date") as "Month Only"
,year("Date") as "Year Only"
;
LOAD date(today() - recno()) as Date
AUTOGENERATE 365
;
Try like:
FiscalCalendar:
Load Dual(fYear-1 &'/'& fYear, fYear) as FYear, // Dual fiscal year
Dual([Calendar Month], fMonth) as FMonth, // Dual fiscal month
Dual(fYear&'-'&'Q'&Ceil(fMonth/3), fYear*100+Ceil(fMonth/3)) as FQuarter, // Dual quarter
'Q'&Ceil(fMonth/3) as fQuarter,
*;
Load [Calendar Year] + If([Calendar Month]>=$(vFM), 1, 0) as fYear
Mod([Calendar Month]-$(vFM), 12)+1 as fMonth, // Numeric fiscal month