0 Replies Latest reply on Apr 27, 2016 9:48 AM by ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD

    Based on Two individual calender prompts ,two individual columns must change?

    ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD

      Hi,

      I have created two presentation variables @{OSM_007_CME} for current month end column, @{OSM_007_PME} for previous month end column.

       

      one calender prompt for current month end:

      TIMESTAMPADD(SQL_TSI_DAY,DAYOFMONTH(MAX("GL_BAL_CRF"."BUSINESS_DATE")) * -1 , TIMESTAMPADD(SQL_TSI_MONTH, 1, MAX("GL_BAL_CRF"."BUSINESS_DATE")))

      second calender prompt for previous month end:

      TIMESTAMPADD(SQL_TSI_DAY,DAYOFMONTH(TIMESTAMPADD(SQL_TSI_DAY,DAYOFMONTH(MAX("GL_BAL_CRF"."BUSINESS_DATE")) * -1 , TIMESTAMPADD(SQL_TSI_MONTH, 1, MAX("GL_BAL_CRF"."BUSINESS_DATE")))) * -1 , TIMESTAMPADD(SQL_TSI_MONTH, 0, TIMESTAMPADD(SQL_TSI_DAY,DAYOFMONTH(MAX("GL_BAL_CRF"."BUSINESS_DATE")) * -1 , TIMESTAMPADD(SQL_TSI_MONTH, 1, MAX("GL_BAL_CRF"."BUSINESS_DATE")))))

      In my report,3 columns are there current month end, previous month end, growth rate.

      in current month end column : i put formula like;

      FILTER(IFNULL("GL_BAL_CRF"."LCY_BALANCE",0) USING (MONTH("GL_BAL_CRF"."BUSINESS_DATE") IN (MONTH(@{OSM_007_CME}))))

      in previous month end column : i put formula like;

      FILTER(IFNULL("GL_BAL_CRF"."LCY_BALANCE",0) USING (MONTH("GL_BAL_CRF"."BUSINESS_DATE") IN (MONTH(@{OSM_007_PME}))))

      Please see the below scree shots

      104.png


      I am getting data when i select 1st calender : oct-31-2015 & 2nd calender : sep-30-2015

      101.png



      102.png

      in my database, october month data  only ..

      My requirement is,  I am not getting data when i select 1st calender : nov-30-2015 & 2nd calender : oct-31-2015.

      october data not getting in second column (i.e previous month end). that means 1st column has november data..

      I have tried so many times..please help me

       


      Thanks in advance

      A.kavya