Good work Bernie, I wondered if someone would catch me on this apparent inconsistency. However, in this case, we're looking at an OLD throwback to R:Base 4000 report expressions and it works just fine without the dot. In fact, I'm surprised it works WITH the dot!!
David Blocker ----- Original Message ----- From: "Bernie Corrigan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 21, 2001 4:44 AM Subject: Re: Summing Variables > David - > > To quote Razzak from "Understanding Dotted vs. Ampersand Variables": > > 04. A rule of thumb for when to "dot" a variable is to always "dot" > the variable when it is on the right side of the operator. > > 07. Dotted variables are used in Form and Report expressions as they > are in the SET VAR command. On the right side of the operator, > dot the variable. > > Looks like a Report expression to me and looks like the variable is on the > right side. > > Bernie > > > > At 10:06 PM 11/20/2001 -0500, you wrote: > >Dennis > > > >This is worth a donation to Sami - didn't you read Razzak's email about > >variables? NO dot is needed. > > > >NOT: rvSumWhatever = SUM OF .vWhatever > > > >but instead: rvSumWhatever = SUM OF vWhatever > > > >David Blocker > > > >----- Original Message ----- > >From: "Dennis McGrath" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Sent: Tuesday, November 20, 2001 7:44 PM > >Subject: RE: Summing Variables > > > > > >> I never use the create aggregate function interface. > >> Instead, I create my sum variable as follows > >> > >> rvSumWhatever = SUM OF .vWhatever > >> > >> Never a problem. It would be a major step backwards for R:Base reports if > >> SUM OF on variables ceased to work entirely. There are nifty tricks you > >can > >> play with variables that just don't cut it any other way. > >> > >> -- Dennis McGrath > >> mailto:[EMAIL PROTECTED] > >> > >> -- Productivity Tools for R:Base Programmers > >> http://www.enteract.com/~mcgrath/dennis > >> > >> -- Full time consultant with: > >> SQL Resources Group > >> Steve Hartmann > >> Oak Park, IL > >> mailto:[EMAIL PROTECTED] > >> > >> > >> -----Original Message----- > >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > >> Behalf Of Richard S. Croy > >> Sent: Tuesday, November 20, 2001 3:58 PM > >> To: R:Base List > >> Subject: Summing Variables > >> > >> > >> Am I missing something somewhere in R:Base 6.5++ > >> > >> I have a report with three columns, for each of which I want > >> to accumulate subtotals at the end of each page, and grand > >> totals at the end of the report. > >> > >> The columns, all currency, are Subscription Fee, Payment > >> Received, and Variance (this being the difference between > >> the previous two). > >> > >> Every time that I try to define a variable to sum up these > >> variable columns, R:Base tells me "No way." > >> > >> When I try the "Create Aggregate Functions", the dialog > >> only allows me to work with columns, not variables. > >> > >> I had a similar report in R:Base 6.5/6.5+ which let me do > >> just what I want to do here, but I'll be darned if I can > >> figure out how -- if it is possible at all -- to do it in 6.5++ > >> > >> Dick Croy > >> > >> -- > >> Richard S. Croy > >> [EMAIL PROTECTED] > >> > >> > >> > >> > > > > >
