Sum columns in a row

[bradralston]

I am trying to figure out how to calculate the total from columns in a row. I can get the total right with only one item, but when I get the second item, it sums both.

What I need :

Item CostA CostB Total
001 10 20 30
002 10 30 40

What I Get :

Item CostA CostB Total
001 10 20 30
002 10 30 70

help please. thanks.

[brucevde]

A simple formula that adds CostA + CostB should be all you need.

[bradralston]

I tried a simple formula but it sums the values from row 1 into the values of row 2. I guess I need it to clear out each time it hits a new group.

[brucevde]

Do not use the Sum function.

The formula would simply be.

{TableName.CostA} + {TableName.CostB}

Then place it in your details section.

Show your formula.