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?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
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?
0
Commented:
If it is a running total you could reset on both by using a formula.

mlmcc
0
Author Commented:
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
0
Commented:
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.
0
Author Commented:
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
0
Commented:
{GroupFIled} <> Previous({GroupField})
OR
{Acolumn} = 'B'

mlmcc
0

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Author Commented:
Yay! thanks very much
0
Commented:
Forced accept.

Computer101