calculating YearToDate , 0calquarter from fiscal year/period
I need to get the data for YearToDate . I need extract the data from a custom table.
And this table contains Fiscal year and fiscal period.
So how can i get the "Year To Date" based on fiscal year and fiscal period.
And how can i get the 0calquarter from fiscal year/period.
please let me know
You can try this:
first derive Calmonth from fiscal period using formula: FISCPER_CALMONTH Calculate Calendar Month from Fiscal Period (PPP -> YYYYMM)
From period, derive quater. OR.
Option2: Usally 01, 02, 03 periods falls into quater1, 04,05,06 in Qtr2....etc.
based some logic also Quater can be derived from Period.