Jim,
rvTypeATotal = SUM (IFEQ(ColT,'A', (ColQ * ColC), 0))
rvTypeBTotal = SUM (IFEQ(ColT,'B', (ColQ * ColC), 0))
Bill
On Wed, 6 Jun 2001 09:53:50 -0400, J. Andrus wrote:
>RBWIN 2000, Ver 6.5+, Build 1.839xRT03
>
>Table: tablename
>Columns: colC Currency, colQ Real, colT Text
>
>In the report based on tablename each detail line has a vtotal which is
>(colQ * colC) where colT for that line can be any one, for simplicity, of
>two types, A or B.
>Is it possible to show, in the report footer, the total for type A and the
>total for type B without adding a column to the table containing the value
>of (colQ * colC) or determining these two totals in a command file prior to
>running the report?
>
>Jim
>
