### Title

Problem with Column Totals

### Post

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.

Jim

What you describe does not "add up" in more ways than one. I think you need to describe your design in more detail.

If cost 1 and Cost 2 are number fields defined in the layout's (or a portal's) table, then Cost1 + Cost2 should compute the sum of those two fields. But what you describe is more typical of incorrectly implemented summary fields in stead of fields of type calculation.