20 Replies Latest reply: Jun 21, 2011 6:00 AM by Ania Vasconcellos RSS

    Aggregating excluding Null

    Ania Vasconcellos



      Is there anyway to do an aggregation function without including the Null values? I have created a band that is creating values that are Null within the Dimensions tab. I have tried suppressing when the values are Null, but this does not work as my Expression which contains the aggregation still shows the sum including the Nulls. I have also noticed that the Label that is given to the Dimension cannot be used in the expression, as I would have liked to have used the set analysis to exclude it.


      Any suggestions?


      Thanks, Ania