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

    Aggregating excluding Null

      Hi

       

      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