EveBit fixes bug, contributing Magento development

As a professional development team o

f Magento, EveBit recently fixes a bug exsting on the latest version of Magento: v1.4.0.1, it's about a problem in Lifetime Sales calculation.

The full disscusion can be seen at: http://www.magentocommerce.com/boards/viewthread/198624/, and following is the general description about this bug:

----------------------------------------------------------------------------------------------

I have a problem in Lifetime Sales calculation.

All orders grand total sum together is $6.2. But in the Dashboard, the Lifetime Sales is almost $238.80!!!! that is very strange,
so I checked the core code.

/app/code/core/Mage/Adminhtml/Block/Dashboard/Sales.php

the Lifetime Sales SQL statement is as below:

SELECT `e`.*, SUM((e.base_subtotal-IFNULL(e.base_subtotal_refunded,0)-IFNULL(e.base_subtotal_canceled,0)-IFNULL(e.base_discount_amount,0)+IFNULL(e.base_discount_refunded,0))*e.base_to_global_rate) AS `lifetime`, AVG((e.base_subtotal-IFNULL(e.base_subtotal_refunded,0)-IFNULL(e.base_subtotal_canceled,0)-IFNULL(e.base_discount_amount,0)+IFNULL(e.base_discount_refunded,0))*e.base_to_global_rate) AS `average` FROM `sales_order` AS `e` WHERE (e.entity_type_id = 11) AND (e.state != canceled) GROUP BY `e`.`entity_type_id`

the problem I thought is in the SUM function in the SQL statement. the e.base_discount_amount in the SQL statement is a negative number(-59.4000).  so negative negative is positive. so here, actually, is e.base_subtotal(60.0000) - discount_amount(-59.4000). I have 7 orders, 5 orders are free, not need to pay. the two paid orders are the same.
finally:

Lifetime Sales = (e.base_subtotal(60.0000) - discount_amount(-59.4000)) * 2;
Average Orders = Lifetime Sales / 7

I also check the Shipping Cart Price Rules, action tab, the Discount amount is a positive value, and the Apply is set to percentage of product price discount
so, does anyone can tell me why the Lifetime Sales is so far to the actually grand total?

Do I misunderstanding the meaning of Lifetime Sales or set the wrong Shipping Cart Price Rules?

Thanks in advance.

----------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------

Solution:

In the file:

/app/code/local/Mage/Reports/Model/Mysql4/Order/Collection.php

line 204:
Original:
({{base_subtotal}}-IFNULL({{