I have a SOQL query that I'm trying to use the SUM function with. My issue is that the SUM function gives me a totally different result than if i just query the rows and add up the amounts
Query 1 - Selecting the rows individually
select id, Parts_Cost__c from customObject where Status= 'Completed'
and Contract = :contractId and Completed_On__c >= :contractStartDate
and Completed_On__c <= :contractEndDate
select id, Parts_Cost__c from customObject where Status= 'Completed'
and Contract = :contractId and Completed_On__c >= :contractStartDate
and Completed_On__c <= :contractEndDate
The individual results for parts cost sum to- 6773.59 and 17 rows are returned
Query 2- Aggregate Results:
select count(id), sum(Parts_Cost__c) from customObject where Status= 'Completed'
and Contract = :contractId and Completed_On__c >= :contractStartDate
and Completed_On__c <= :contractEndDate
select count(id), sum(Parts_Cost__c) from customObject where Status= 'Completed'
and Contract = :contractId and Completed_On__c >= :contractStartDate
and Completed_On__c <= :contractEndDate
This will give me a summed value of 8036.05 and the count result is 17 rows.
Can anyone think of reasons for these discrepancies in the results? Can I see how the 8036.05 is getting calculated?
