Hi bondimedical,
Personally, I'd do this in Excel. It'd be far simpler.
Your existing formlae have some problems. Did you notice how, with no line totals your invoice has values in the sub-total, GST & total cells? That's courtesy of SUM(ABOVE) trying to add up the numbers in the date, customer ID, etc. Splitting the table above the 'line total' row will solve that. However, I'd strongly recommend against using SUM(ABOVE) anyway, for the reasons outlined in the Maths tutorial.
As for calculating each row's line total, you'll need a formula field like:
{=A$$*D$$-E$$ \# "0.00;;"}
in each 'line total' cell, where $$ is the row number. Even then, unless you're using formfields with the 'calculate on exit' attribute set in columns A,D&E, the values won't automatically recalculate. See attached.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|