Skip to Content
Former Member
Sep 15, 2014 at 06:39 PM

Problems with running totals


I'm having some trouble getting the correct number when a drive has multiple incentives associated with the drive. And to explain as fully as I can, every drive has a projecture procedure count and when complete, a performed procedure count associated with the drive. And when a drive has an incentive assigned to it, I would like to count the drive's projected and performed procedure count to the incentive count. In the screen shot, there are five drives with four each having one incentive to the drive. The incentive count in which only one incentive is assigned to one drive is correct, but the Fandango pre-drive and post-drive counts are off because it is not counting the 12 and 15 that were collected on the bottom drive.

For my running total, I am summing the ProceduresPerformed field, evaluating on the change of field of DriveID (each drive) and reseting on the change of field for EquipmentID (each incentive has its own unique ID).

What would be the best way to handle drives with multiple incentives to get the correct count?