Wrong AVG calculation in Drill Down with null values

Technical support

Moderators: Bob Cergol, Data Access, Cintac

Wrong AVG calculation in Drill Down with null values

Postby samuel » Tue Sep 21, 2010 4:54 am

Hi,

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
Attachments
DAI_Wrong_Average_1.png
DAI_Wrong_Average_1.png (31.08 KiB) Viewed 4221 times
DAI_Wrong_Average_2.png
DAI_Wrong_Average_2.png (46.1 KiB) Viewed 4221 times
Samuel Pizarro
Estância Árvore da Vida
samuel
 
Posts: 15
Joined: Mon Jun 16, 2008 3:21 pm
Location: Brazil

Return to Technical Support

cron