GeorgeSalet

asked on

# 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

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

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**ASKER

Perfect

Thanks for the help

George

Thanks for the help

George

Group 1

callback

callback

==========

1

Group 2

callback

============

2

mlmcc