deriving Calendar Year/Month
Here's the big question.
In my manual planning application, user chooses Fiscal Year, say 2008.
In the layout, I have Calendar Month as data columns restricted to 1-12 (Jan - Dec).
So, once user enters the plan dollars, I want to have a function that takes the dates (Fiscal Year and Calendar Month) and derives the values for 0CALMONTH (Calendar Year/Month).
Remember, Fiscal year and Calendar Month being entered currently are independant of one another. But, Calendar Year/Month (0CALMONTH) is a combination of both.
how do we do this in BPS ?