|
-
December 21st, 2010, 10:23 AM
#1
Double counting running totals
Trying to write a productivity report which measures tasks that users complete (running totals from 1 table) and the time they were logged in from another (last logout - first log in).
after i've added the login measure to the report it duplicates the running totals based on the amount of login/logout records there are for each user (i.e. if they've logged in and out of the dB 3 times then their running totals will be 3 times the correct figure)
Any ideas?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|