Calculation field for Total of Subtotals

[redcalx]

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!

[Fitch]

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.

[redcalx]

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.

[Fitch]

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