1 Reply Latest reply: Mar 12, 2013 4:35 PM by Manoj Kumar Varatharajan RSS

    Set Analysis

    Hardik Gandhi

      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