Skip to Content
0
Former Member
Apr 04, 2014 at 06:51 PM

Summary (Running Total) Field is not performing as expected

154 Views

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?

Attachments

Shift_Totals.png (70.7 kB)