2 Replies Latest reply: Mar 25, 2014 10:02 AM by Colin Devon RSS

    Point in Time Analysis - Assigning verbalised labels for reporting year

      Wanting to do a table that has the current reporting year and the previous N years.

       

      Very Basic Straight Table

      2011/122012/132013/14
      1,5001,6001,450

       

      Not a problem for the definition but with the label I can only think of using the following below which does but I was wondering if there was an easier or more elegant way.

       

      Variables

      vDaytoDateReportingYear=DayNumberOfYear(Max({<Dimension_Category-={0} > } Date), 4)

      vCurrentReportingYear=Max({<Dimension_Category-={0} > } Reporting_Year)

       

      Expresion Definition

       

      =SUM({< DayOfReportingYear={"<=$(vDaytoDateReportingYear)"}, Reporting_Year={"$(=vCurrentReportingYear-3)"}, Fact_Count)

       

       

      Expression Label

      =FieldValue('Reporting_Year_Verbalised', FieldIndex('Reporting_Year_Verbalised', vCurrentReportingYear-3))

       

      where

       

      Reporting_Year = 2014

      Reporting_Year_Verbalised = 2013/14