Bill
I believe you must set your var like this
vTotCol2 = (.vTotCol2 + (IFNULL(Col2,0,1)))
Buddy
-----Original Message-----
From: Bill Eyring [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 10:38 AM
To: Rbase Mail List (E-mail)
Subject: Multiple Count Aggregate Report Variables
I have recently had the need to create a report with multiple aggregate
report variables using the count function. I am working with Rbase for
Windows 6.5++ build 1.851xRT03.
The first column in the report all have not null values. The succeeding
columns may or may not have values. Logically then you would expect that the
aggregate count variables at the end of the report would have different sums
for each column since the count function is supposed to include only not
null values. That, however, is not the case. The sum of each variable is the
same as the largest aggregate variable sum.
In my report I defined each aggregate variable by choosing Variables,Create
Aggregate Variables,Select column Name,Select function(Count) and then add.
Each aggregate variable is based on a different column. I then placed each
aggregate variable in the report footer underneath each column. When you
check Variable,Change Section each variable is calculated on the Detail
section.
The report has only 3 sections - ReportHeader,Detail and ReportFooter.
There are no break headers or footers in the report. The SHOW CHAR command
at the R> prompt shows;
Quotes= '
Plus= +
Single= _
Many= %
IDQuotes=`
The settings for ANSI,ZERO or Null does not change the result of the
aggregate variables.
Here is an example:
IdNum Col2 Col3 Col4 Col5
X X X
X X X X
X X X
X X
X X X
Totals 5 5 5 5 5
The correct totals should be;
5 3 1 4 2
I have reported this to Rbase Technical Support and they were good enough to
suggest a workaround.
Can anyone replicate this problem or suggest an answer to this problem ?
Thanks,
Bill Eyring
Director of Information Systems
Michael Haberman Associates, Inc.
125 Front Street, Mineola, N.Y. 11501
516-739-8080
Rbase Developer
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
