-
Sum columns in a row
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.
-
A simple formula that adds CostA + CostB should be all you need.
-
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.
-
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.