Hi Drew, eventually I've tried your database (paolo.odb) and it works fine. So I've changed my functions according to your example, and now they work fine on my data as well! What was causing the errors in the subtotal: I was using [field] alone as a starting value in the function definition; changing it to IF(ISBLANK([field]);0;[field]) solved the problem.
I've registered to thw wiki, and I'll try and add this to share. Thanks for your help. Paolo On Friday 12 October 2007 22:36:30 Drew Jensen wrote: > Hi Paolo, > > I haven't updated the wiki pages, but for now. > > You can download a database I have set up for you at > http://www.paintedfrogceramics.com/OpenOffice/SRB/Paolo.odb > > In the database you will find a single report. > > The report uses functions to create the sub totals, a grand total, for > records with NULL in the cost field the string NULL is printed in red on > the report. I believe it covers all the example cases that you have > asked about. > > If you have questions feel free to ask. Meanwhile I'll update the page > at wiki with a small explanation of the steps in creating the report. > > Drew > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] -- Paolo --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
