Hello,
I'm trying to create a running total of Procedures for a report where a view contains two items in the "Type" field: Procedures or Products.
The running total is set to summarize DriveShiftCollectionsView2.Collected, Evaluate on a formula of {DriveShiftCollectionsView2.Type}="Procedure", and Reset on change of field DriveShiftCollectionsView2.DriveShiftID.
But the totals that CR is displaying do not match the totals from my SQL query at all and I am not sure at all where the numbers CR is displaying are coming from.
Any suggestions?