Problem with Column Totals
I'm a fairly new FM12 user so please bear with me.
I have a very simple table which has two columns containing material costs: Cost1 and Cost2.
At the bottom of this table I display the totals of each of these columns. For example $400 for Cost1 column and $600 for Cost2 column.
In an attempt to display total costs I added a third column "Total Cost" and used the formula Cost1+Cost2.
The problem is that every record in my table displays $1000 and at the end is the grand total of ALL records.
Suggestions greatly appreciated.