Sum function sums incorrectly when one-to-many fields are defined in the criteria of the query

Users get incorrect totals when adding educational history criteria to a Constituent query that contains revenue amount(SUM) in the output.
SQL server is what is actually doing the summing, and it’s following standard query rules.  If your query is going to be doing any kind of aggregation such as summing up a column, it has to group on all other columns in the query in order to perform any kind of summing. 



Was this article helpful?