11 Replies Latest reply: Aug 28, 2013 8:36 AM by Fernando Tonial RSS

    above return NULL on the first dimension

      I have the following Data

       

      Dimension : 2013 - 2012 - 2011

      Expression: = above([Trade Receivables]) - ([Trade Receivables]

       

      Now, when i run the formula and i select the dimensions 2011 - 2012 - 2013, i have the following results

       

          

      2011     : -

      2012     : 5.000

      2013     : 7.000

       

      How can I change the formula so that the data for 2011 dissapears ? I would like to select the data 2012 - 2013 in my dimenstion and obtain the same results as above without 2011.

       

      thanks for you help in advance