5 Replies Latest reply: Aug 19, 2016 5:35 AM by Shazad Nazir RSS

    Current Fiscal Year Revenue & Last Fiscal Year Revenue

    Shazad Nazir

      Hi Experts,

       

      While calculating the Revenue for Current and Last fiscal year:

       

      Variable is being used are as follows:

      1. CurrentYear  Expression: Max(Right(FiscalYear,4)) -1 & '-' & Max(Right(FiscalYear,4)) Resultant > 2015-2016
      2. LastYear Expression: Max(Right(FiscalYear,4)) -2 & '-' & (Max(Right(FiscalYear,4))-1)  Resultant > 2014-2015

      Variables result has been tested by pasting them in charts > KPI.

       

      Master Items Created with Expressions as follows:

      1. RevCurrentYear Expression:
        1. Sum({<FiscalYear = {'$(CurrentYear)'}>}RowTotal) Does not work
        2. Sum({<FiscalYear = {'2015-2016'}>}RowTotal) works fine
      2. RevLastYear Expression:
        1. Sum({<FiscalYear = {'$(LastYear)'}>}RowTotal) Does not work
        2. Sum({<FiscalYear={'2014-2015'} >} RowTotal) works fine

       

      * Variables in the Master Items: RevCurrentYear & RevLastYear are not working, can somebody please help