Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thank you. I guess I will have to re-look at the way I am going about this
problem. I may just take your advice and script it.
Thanks again.
Ania
On 21 June 2011 11:56, Kaushik.solanki <