By default, Pay Cash is not included when querying on Summary Information. This is intended to avoid duplicate counting in the summary results.
This must be addressed by adding an additional criteria to define which gift types to include, for example: "Gift Type equals one of Pay Cash, etc. etc."
Refer to What Gift Types are included by default in a Summary Information Total Amount Query for more information on which gift types are included and excluded by default when running this type of query.
Blackbaud Community
Connect and collaborate with fellow Blackbaud users.