I am trying to average an annual report in a crosstab.
The problem is the average is worked on the number non-zero rows.
So, if no data in <say> November, the calculation is done dividing by 11.
I need the average to divide by 12 - as in months in the year.
Rather than an average of months where something happened.
How can i achieve this please?
I am even happy to hardcode the number 12 somewhere, and select only 12 month periods, but where/how to put it