AnsweredAssumed Answered

Problem with Column Totals

Question asked by jimwolfe on Jan 30, 2014
Latest reply on Jan 31, 2014 by jimwolfe


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.