6 Replies Latest reply: Apr 27, 2014 2:17 AM by Prashant Sangle RSS

    Comparison with the previous year


      I want to compare in a simple table the amount for the year I have selected with the preceding year.

       

      I am making a mistake in the definition of the expression for the preeding year because the table does not display any data.

       

      This is what I´m doing:

       

      FOR THE YEAR SELECTED: It works

      • LABEL:

                      $(=Max(MbrName_Anio))

      • DEFINITION:

                         ({$ <[MbrName_Anio]= {$(=Max(MbrName_Anio))} > } [Importe real]

       

      FOR THE PRECEDING YEAR: The Label works but the Expression don´t

      • LABEL:It works

                      $(=Max(MbrName_Anio)-1) 

      • DEFINITION: It doesn´t work

                       ({$ <[MbrName_Anio]= {$(=Max(MbrName_Anio)-1)} > } [Importe real])  

       

      What am I doing wrong?

      Thanks in advance for your answers!!