running total by group

Hi Experts
I am trying to create a running total that provides a total based on groups using a formula.
each group has multiple record and the running total is counting each record that is true to the formula, I want to count only 1 for each group no matter how many records are in the group

I am summarizing on InvType
using a count
Evaluating with formula : invType = "callback"
Reset never

my data looks like this:

Group 1
  callback
  callback
==========
       1
Group 2
  callback
============
        1
if I could evaluate with a formula for each group that should solve the problem?? I Think
George
GeorgeSaletAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
GJParkerConnect With a Mentor Commented:
So if i'm correct all you want to show is a 1 if any record in the group has an invtype of 'callback', is that correct ?

If so create a new formula

//@Callback
If :Tabl.InvType} = 'callback' Then 1

Then add a summary showing the max of this field in the group header.

HTH
0
 
mlmccCommented:
So what you want is

Group 1
  callback
  callback
==========
       1
Group 2
  callback
============
        2


mlmcc
0
 
GeorgeSaletAuthor Commented:
Perfect
Thanks for the help
George
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.