Oma, Bill, Albert, & Dr.R.
Unfortunately in my attempt to simplify the problem I left out a very
important condition which, I think, means I will have to pursue Razzak's
approach.
I failed to mention that I need to meet the where condition "between two
dates" where the computation is performed for both A and B rather than use
all values for A and B types from the table, and I haven't been able to
figure out how to incorporate such a condition into the vtot variable
calculation
Although it really doesn't matter if it is not possible to work the "where"
condition into the vtot variable calculation, In trying the
"sum(IFEQ(colQ.........)" approach (assuming no where condition) I did
encounter an error and can't see where I deviated from your examples. The
error message reads "Cannot recognize "OF" in sum of (2188)". I definitely
didn't have "of" after sum.
Thanks for your suggestions which are greatly appreciated.
Jim
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Oma Cox
> Sent: Wednesday, June 06, 2001 11:10 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Report Totals
>
>
> Jim,
>
> If I understand your question is how to give a total for the items type
> defined in colT - A & B.
> Define Report Var as follows:
>
> vtotA= sum (IFEQ(colT,'A',(colQ * colC),0))
> vtotB= sum (IFEQ(colT,'B',(colQ * colC),0))
>
> If you have a lot of types or they are dynamic in nature then this means
> adding a lot of var!
> Adding the extra column and using code before the report is
> generated is the
> best bet if you don't have a fixed amount of types.
>
>
> Best regards,
>
> Oma
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of J. Andrus
> Sent: Wednesday, June 06, 2001 8:54 AM
> To: RBase
> Subject: Report Totals
>
>
> 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
>
>
