Account Name Account Code Department YTD Actual Approved Budget
License Fee 100 1000 2000 10,000
Calendar Field Available : YEAR and MONTH-YEAR
I want to display Approved Budget based on following rule:
---- " A user can select any Year value or Month-Year field. The Approved Budget should populate according to the Year selected and the Month should always be december of that year for any month-year selected.
For Example:
User selected: Year 2012 and Month: June (Actual budget: should be DEC-2012)
if user selects: Year 2011 and Month: March (Actual budget: should be DEC-2011)
Account Name Account Code Department YTD Actual Approved Budget