Count of values in a group and only in that group

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am writing a report where it is running a count and sum of two values in a
group, for multiple groups.

It works fine for the first one, but it takes the results from the first one
and tallys it onto the second group and so on.

Here is the report so far.

loadDate (Group header)

(details) loadSQRFoot ordShipped ordLate sqrtypeName

(Group Footer)
Count of sqrtypeName and Sum of that count


Here is the formulas that I use:

=Abs(Sum([sqrtypeName]="Pick-Up")) - There is three values for sqrtypeName.
Pick-Up, Local, Long. This gives me the count.

=Sum(Abs([sqrtypeName]="Pick-Up")*[loadSQRFoot]) - This just sums up the
data for the group of that type.

Is there a reason why it is tallying this data on for each group as it goes?
 
Keldair said:
I am writing a report where it is running a count and sum of two values in a
group, for multiple groups.

It works fine for the first one, but it takes the results from the first one
and tallys it onto the second group and so on.

Here is the report so far.

loadDate (Group header)

(details) loadSQRFoot ordShipped ordLate sqrtypeName

(Group Footer)
Count of sqrtypeName and Sum of that count


Here is the formulas that I use:

=Abs(Sum([sqrtypeName]="Pick-Up")) - There is three values for sqrtypeName.
Pick-Up, Local, Long. This gives me the count.

=Sum(Abs([sqrtypeName]="Pick-Up")*[loadSQRFoot]) - This just sums up the
data for the group of that type.

Is there a reason why it is tallying this data on for each group as it goes?
Click to expand...


It sounds like you have set the RunningSum property.
 
That did it, thank you much. No clue how it got set, but thank you much.

Marshall Barton said:
Keldair said:
I am writing a report where it is running a count and sum of two values in a
group, for multiple groups.

It works fine for the first one, but it takes the results from the first one
and tallys it onto the second group and so on.

Here is the report so far.

loadDate (Group header)

(details) loadSQRFoot ordShipped ordLate sqrtypeName

(Group Footer)
Count of sqrtypeName and Sum of that count


Here is the formulas that I use:

=Abs(Sum([sqrtypeName]="Pick-Up")) - There is three values for sqrtypeName.
Pick-Up, Local, Long. This gives me the count.

=Sum(Abs([sqrtypeName]="Pick-Up")*[loadSQRFoot]) - This just sums up the
data for the group of that type.

Is there a reason why it is tallying this data on for each group as it goes?
Click to expand...


It sounds like you have set the RunningSum property.
Click to expand...
 
Back
Top