So here is the issue:
I working with an audit table (A_DOC) that tracks every change to a record in the DOC table, when the change was saved (A_DOC.LASTUPDATE), and who made the change (A_DOC.UPDATEWHO)(Foreign Key from person table)
I'm tracking who originally created each document (earliest record in audit table) and how many documents they created.
Here's what I did:
- Grouped by primary key (A_DOC.ID
- Sorted by date saved (A_DOC.LASTUPDATE) in descending order
So I created a formula (@PERSON1) for each person:
I put the formula in the details section and in the group footer put a TOTAL of the formula (using MAXIMUM because users make multiple changes).
I put the formula in the group footer (the last record in the group will be the first record because of the sort)
The problem is when I'm trying to total the number of documents each person (sum of the number in the footer). I can't seem total another total field (PLAN A).
Or (PLAN B) I can get:
Total number of changes (Count on @PERSON1 for each record) or
Total number of documents (count on @PERSON1 change of group).
No matter what I can't seem to get a proper total of the number of documents created rather than the number of edits in total