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
