3 Replies Latest reply: Apr 7, 2013 11:57 PM by Stephane DUGUET RSS

    Above() displaying additionnal lines with no data

    Stephane DUGUET

      Dear All,

       

      When trying to build an Incremental sum in a complex table with many condition, using the above() function in an expression display row that were hiden before because there was no data in the others expressions.

       

      I've attached a basic sample stripped of complexity, with the top 3 table using above() and rangsum(above( with no issues as there is no specific limits.


      Then the 3 bottom tables have in the main Indicator, the basic sum, a IF that limit the sum to some dimensions values.

      In this case when I add Above, hidden lines reapear with no data.

       

      How could I use above and hide thoses lines ?

       

      Above.png