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?
WarwicklAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
{GroupFIled} <> Previous({GroupField})
OR
{Acolumn} = 'B'

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

mlmcc
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
WarwicklAuthor 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
 
wykabryanCommented:
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
 
WarwicklAuthor 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
 
WarwicklAuthor Commented:
Yay! thanks very much
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0
All Courses

From novice to tech pro — start learning today.