Hello! I'm struggling with setting up a dsum expression that captures the information I want, calculating a running sum that resets based on a category number.
I'm working on a goal setting tool in a production environment. I have a goal time calculated for each job scheduled to a machine. I'm trying to capture a running sum so I can evaluate at what point the total goal time exceeds the time in a shift for each machine.
As you can see below, I've been successful getting a dsum set up that will work for all of the jobs (sequence#), but I need it to reset to 0 when it moves from press N02 to N03 and so on. The expression used to create the below is:
Rs: DSum("[Goaltime]","[tblPressGoals_Efficiency]","[Sequence#]<=" & [Sequence#])
When I try adding "Press" into the criteria, it either gives me an error, repeats the same total for every record, or comes up blank.. Hoping someone here can help me out?
Press Sequence# GoalTime Rs N02 14907 52.528 52.528 N02 14909 266.728 319.256 N03 14916 69.23 388.486 N03 14917 76.58 465.066 N03 14918 98.84 563.906 N03 14919 98.84 662.746 N03 14920 100.31 763.056 N03 14921 98.84 861.896 N03 14922 98.84 960.736 N03 14923 89.32 1050.056 N03 14924 98.84 1148.896