Form field calculation returning 2x correct result
Hi and thanks for reading,
I'm new to working with this type of field/calculation so please bare with me if I'm making an obvious mistake. I've attached a table containing some calc fields (Columns E & G, and all rows in bold) that are not working as I expect. Protection is not enforced in order to allow a look at the field formatting, though it is when the table is in use.
Column G is the sum of columns E & F, but the calculation somehow is doubling the amount in column E. The same occurs in each bold row (sub and grand totals). For example, "personnel total" should be a sum of the amount for each itemization, but in column G it is double the sum.
What am I doing wrong? I can't seem to figure it out. Thanks!
BTW, Windows 7 and Word 2010.
|