漏洞

In infographics, when calculating an average for store sales, some store sales are null values, but selecting 'ignore nulls' in the dialog converts the NULLs to 0 and then includes those zeros in the average calculation, resulting in inaccurate statistics.