Re: Totalling expressions "AFTER GROUP OF" in ACE
Posted in 1995
} From: kcj@netcom.com (Kate Juliff) } Subject: Totalling expressions "AFTER GROUP OF" in ACE } Date: Thu, 20 Jul 1995 00:27:02 GMT } To: informix-list@rmy.emory.edu } } I have a report (ACE) with a select with order by on columns x, y and x. } I have a report break on x where I want to print the total of a computed } field ((column a/100) * (column b /100)) and I'm doing it this way: } after group of y } print total of ((a/100)*(b/100)) } } However though the total is correctly printed after the first group } output, it NEVER changes! What am I doing wrong? } Kate, PRINT TOTAL OF thinks you are printing final totals. Add GROUP modifier to get just one group's information. after group of y print group total of ((a/100)*(b/100)) -- Jim Buchalski (jamesb@informix.com) Atlanta, GA USA