Joined: 27 Aug 2007
Location: United States
Online Status: Offline
Posts: 2
Topic: Summary or Running total? Posted: 27 Aug 2007 at 10:37am
I have a running total set up that tallies the hours for a given employee based on the week, so it adds the hours that week for a running total, then resets and starts from zero, tallies for that week for a running total, etc. I want to have the report display just the highest value before the running total resets for the following week. Should I even be using a running total at all or should I try a summary? I am most confused.
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 28 Aug 2007 at 7:38am
This would be a good place to use a summary instead of a running total if you are grouping by week. Summary functions can only be calculated at the group and report level. Running totals can be reset on conditions that have nothing to do with the groups.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum