1 Reply Latest reply: Jun 12, 2017 1:33 AM by jagan mohan rao appala RSS

    Month on Month Varance..

    sravan Vennu

      Hi All,

       

      I am trying get variance between selected month vs previous month. For this I have assigned MonthID for month, created 2 variables i.e. for CurrentMonth and CurrentMonth -1 and called in Set Analysis.

       

      Just to test I have taken it in text object:

      =sum({<MonthID={$(vMonthID)}>}Actuals)& ' - '&sum({<MonthID={$(vMonthID_1)}>}Actuals)

       

      But when ever I select Month Name from Month field, it's giving the Actuals for selected month but not for previous month.

       

      If I select the Month from MonthID field, that's giving me the correct values i.e. Current Actuals - Previous Actuals.

       

      On Selection of Month Field:

      On Selection of MonthID:

      Need help to show the variance based on Month Name selections.

       

      Note: My Financial Calendar Starts from Oct to Sep. So, MonthID for Nov as 2.

       

      Sample:

      Date:
      LOAD * INLINE [
      ANZ_CalenderDate, Actuals
      01/01/2017, 1000, A
      02/03/2017, 2000, B
      03/02/2017, 3000, A
      04/06/2017, 4000, B
        ]
      ;

      Final:
      LOAD
      ANZ_CalenderDate,
      Month(ANZ_CalenderDate) as Month,
      AutoNumber(ANZ_CalenderDate) as MonthID,
      Year(ANZ_CalenderDate) as Year,
      Actuals
      Resident Date;
      DROP Table Date;

       

       

      Variables:

       

       

      Regards,

      Sravan.V