Hi all
I'm having a problem with a Report.
I'm calculating an average(avg) in a report footer on the score field below =avg([score])
ID Site Name Score
908 Site 1 88.43%
679 Site 2 86.53%
567 Site 3 84.86%
456 Site 4 84.66%
432 Site 5 0.00%
Average 68.90%
Now for the problem I know the Average is right but I want to exclude the 0.00% (it still needs to be shown on the report though). So the average would be 86.12%
Can you think of a way around this?
Thanks in advance
Paul
I'm having a problem with a Report.
I'm calculating an average(avg) in a report footer on the score field below =avg([score])
ID Site Name Score
908 Site 1 88.43%
679 Site 2 86.53%
567 Site 3 84.86%
456 Site 4 84.66%
432 Site 5 0.00%
Average 68.90%
Now for the problem I know the Average is right but I want to exclude the 0.00% (it still needs to be shown on the report though). So the average would be 86.12%
Can you think of a way around this?
Thanks in advance
Paul