The data type and band are correct John
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of A. Razzak Memon Sent: Friday, August 27, 2004 5:37 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: SUM in reports 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
