Jim, There is nothing testing the actual column "shipdate" to see whether it is null or not.
Try this expression, instead: (ifeq(.COUNT_OF_SHIPDATE,NULL,0,.COUNT_OF_SHIPDATE) + (IFNULL(ShipDate,0,1)) ) You may have to SET ZERO OFF for the report. Also, if your data ever has all shipdates blank for a report, you will get division by zero and an error, so you may have to test for that, too, maybe something like this: SHIPAVG = (.VSHIPTOT / (IFEQ(.COUNT_OF_SHIPDATE,0,1,.Count_Of_SHIPDATE)) ) Bill On 1/7/08, Jim Belisle <[EMAIL PROTECTED]> wrote: > > My null setting is '-0-' and my zero setting is set to 'on'. The > expression I use was automatically set by RBASE when I used the aggregate > function in RBASE 6.5. The expressions used in the report are below: > COUNT_OF_SHIPDATE = (ifeq(.COUNT_OF_SHIPDATE,NULL,0,.COUNT_OF_SHIPDATE) + > 1) > VSHIPTOT = SUM OF SHIPDAYS > > SHIPAVG = (.VSHIPTOT / .COUNT_OF_SHIPDATE) > > > ------------------------------ > > *From:* [email protected] [mailto:[EMAIL PROTECTED] *On Behalf Of *Bill > Downall > *Sent:* Monday, January 07, 2008 9:23 AM > *To:* RBASE-L Mailing List > *Subject:* [RBASE-L] - Re: COUNT > > > > Jim, > > What R:BASE version are you using? Can you copy the relevant expressions > from your variables list, and paste them in a message? Also, what is your > NULL setting, and what is your ZERO setting? > > Thanks. > > Bill > > On 1/7/08, *Jim Belisle* <[EMAIL PROTECTED]> wrote: > > > I have a report that should give me the average # of days to ship orders > for each of our customers. I use the aggregate function for > COUNT_OF_SHIPDATE in the detail section that resets in the footer. When > I use the count feature in the table, it gives me the proper number of > ship days and therefore the proper averages. In the report however, it > gives me the total # of orders regardless of the ship date being null. > Do you have any suggestions? > > Jim > > >
