Hi there,

I'm relatively new to filemaker so I hope this doesnt sound stupid...

I've got a database right now for invoices set up, but I want to be able to print a report of invoice numbers and the corresponding subtotal for that invoice... easy enough.

However, in the footer, I would like to be able to print a total of ALL the subtotals mentioned in the report... does anyone know what calculation I would use for that?

Also, if anyone could direct me towards a great learning source for calculations that would be great.

Thanks!

If the invoice subtotal is a calculation field, make a Summary field that is the Total of it, and put that Summary field in a Trailing Grand Summary layout part. If the subtotal is already a Summary field, just put another copy of it in the Trailing Grand Summary.

Thanks fitch, couple more questions though.

If my subtotal field is called "subtotal", and my total substotal is called "total subtotal", I still don't understand how I would make 'total subtotal' a summary that is the total of subtotal... I'm not sure how to write that calculation.

Go to Define Fields, and look at the field types. Don't use a calc field, use a Summary field.