Sum expression not working

[jake7363]

Hi,

In my report, I have a field called "Volume". I have two groupings in the
report, on is "DRS" and the other is "Category". "DRS" is within "Category."

Withing the DRS grouping, I have a field named drsAVG that averages the
"Volume" field. That is working fine.

Within the Category grouping, I have a field named drsTTL, which is to SUM
the drsAVG field. That is not working. I used the Nz function in both the
drsAVG and drsTTL fields, but in the drsTTL field, all I get is 0's.

Where did I go wrong?

Thanks in advance,
jake

 

[Ofer Cohen]

Why do you need to Sum an Avg field, within a group ?

Within a group a Sum of the Avg should be = to Avg, there is only one Avg.

 

[jake7363]

The average field is the only way I could think of to get a volume that is
repeated several times. (Long story). In other words, more than one record
will have data for a job, but each job only has one volume.

I thought of "Hiding", but those records are still included in the Sum. I
want to be able to sum just the one instance of each volume.

I hope that is not too fuzzy of an explanation.

Joe

 

[Ofer Cohen]

In that case try the Avg, but set the field RunningSum to Yes.

So it should accumilate the values in each group

 

[jake7363]

I am guessing that since there is more than one DRS Group within a Category,
that you meant that I should use the Average field in the Category group, set
with the RunningSum as yes.

After doing that, i finally get a value in the total field, but the number
is far less than what it should be, and I am unable to determine exactly what
it is totalling.

Did I misunderstand?

Jake