Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Here is the scenario:
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
License Fee 100 1000 2000 10,000
Declare a variable LET vMonthYear = chr(39)&'DEC'&'-'&YEAR&chr(39); and use the following set analysis and it will work
sum( {$<[MONTH-YEAR]={$(vMonthYear) } >} [ApprovalBudget])