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.
Thanks for the response. I have tried that, and that does not change the aggregation value as it still shows the sum of the numbers including the Nulls. (I did think that strange since I have seen it work before.)
Unfortunately I can't upload the file as it is much too large. I can say that I am using prices that are banded into 6 bands. I am then counting the number of variables that fall into each of those bands. This is done over 3 years. The bands are the calculated field as I had to deflate the values over the 3 years to be able to compare like with like. That is where the Null values are being created. The frequency formula is as follows: