Thanks Coach. I'll give it a try.
Dean
Dean
----- Original Message -----
From: Rick Lane <rickl@...>
To: <vantage@egroups.com>
Sent: Wednesday, August 30, 2000 12:19 PM
Subject: RE: [Vantage] Group Header Total
>
> Hi Dean,
>
> Maybe someone has an easier way, but this is how I do it.
>
> 1) Create a aggregate field using the maximum function, reset on part
> number, and under options select pre-pass. Call it "maxinv" say.
>
> 2) Create a calculated field with the following expression
>
> iif(InvoiceNum = maxinv, UnitPrice, 0)
>
> Replace the UnitPrice in the above expression with whatever field you want
> totalled. This will result in zero until the last invoice number is hit.
>
> 3) Create an aggregate field that totals the calculated field created in
#2
> above.
>
> This should do the trick.
>
> Rick Lane
> Intelligent Systems Integration, Inc.
> 661B Weber Drive
> Wadsworth, OH 44281
> 330-335-5291
> Fax: 330-335-7275
>
> "Helping business make intelligent use of technology"
>
>
> -----Original Message-----
>
> I figured how to get the groups and group header/footer work. Now, how do
I
> get the totals for just the items that are in the group footer.
>
> Thanks in advance.
>
> Dean
>
> We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)
>