John,
In expression definition box you only need:
SUM OF tPrice IN Purchase WHERE Inv# = .vNEW_INV_NO
Make sure to assign the correct data type and associated band.
Very Best R:egards,
Razzak.
At 05:34 PM 8/27/2004 -0400, you wrote:
I tried that, it displays an error 2187 "illegal number of items for expression
John
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of A. Razzak Memon Sent: Friday, August 27, 2004 5:21 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: SUM in reports
John,
Try this:
vTOT_PUR = SUM OF tPrice IN Purchase WHERE Inv# = .vNEW_INV_NO
Very Best R:egards,
Razzak.
At 05:18 PM 8/27/2004 -0400, you wrote:
>Is this a valid expression for a variable in a report? > >vTOT_PUR = (sum(tprice)) in purchase where inv# = .vNEW_INV_NO > >No errors are created when I enter the expression but when it executes it >comes up with the wrong total. > >John
