Wrong AVG calculation in Drill Down with null values
Posted: Tue Sep 21, 2010 4:54 amHi,
I have notice in a list report with AVG calculations, that the drill down result was not the same as the original (previous ) row AVG values.
Please, see pictures attached for clarification!
The problem seems to be a null values from the final rows been converted to zero (0.00) values.
As we know, null values should not be considered for AVG , and Count agregated functions.
Please, let me know if there is a way to avoid this behaviour, or this will need a fix!
Thanks
I have notice in a list report with AVG calculations, that the drill down result was not the same as the original (previous ) row AVG values.
Please, see pictures attached for clarification!
The problem seems to be a null values from the final rows been converted to zero (0.00) values.
As we know, null values should not be considered for AVG , and Count agregated functions.
Please, let me know if there is a way to avoid this behaviour, or this will need a fix!
Thanks