Warwickl
asked on
Crystal - Running Totals, reset on either field formula or Group change
I have a report that is grouped by workers in the company and then each day of the year. The report shows if the worker came to work or was absent. field is either showing an A or a B. I am using a running total to count the number of times A appears, and reset the count when B appears. The issue is that the running total needs to reset when the group changes (to the next worker). How can I write a formula that will reset on either Field change or group change?
wykabryan
if you have a running total there is a reset section that allows you to reset at group level. Is it a true running total or a formula running total?
If it is a running total you could reset on both by using a formula.
mlmcc
mlmcc
ASKER
The running total is counting each time a field is equal to A, if the field is B then the counting resets - so it resets on the formula field. But the counting continues into the next group. I need it to reset on both the formula and the change of group. Not sure how to write the formula to do this
so change the reset to reset on group. And in the evaluate section do a formula something like column = 'A'
Field to summarize - whatever contains that A/B
Type of summary - count
Evaluate:
Use a Formula- Column='A'
Reset
Using a group: Group 1 or whatever group it is.
Field to summarize - whatever contains that A/B
Type of summary - count
Evaluate:
Use a Formula- Column='A'
Reset
Using a group: Group 1 or whatever group it is.
ASKER
I need the count to reset as soon as the field changes from a, as I only want to see any worker that has been away for higher than 5 days. So if the count reaches 5 + then it will appear on the report.
What I have setup is
evaluate - each record
Reset - needs to be both on change of field and on change of group
So I need to write a formula for this but not sure how
What I have setup is
evaluate - each record
Reset - needs to be both on change of field and on change of group
So I need to write a formula for this but not sure how
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yay! thanks very much
Forced accept.
Computer101
EE Admin
Computer101
EE Admin