Ok real simple. I want to sum a column as I create it. The summary bar can do this. How do i move it to another column? If i make another column and use the sum formula it returns the entry for each row, not the total of the two rows, aka not the sum
There are basically two options:
Add rows using the summary bar (which can do subtotals if the view is grouped), or
Link your records to a row in another table and use rollup fields to sum it for you.
- so i have it grouped, but this is not helpful when i need to download it and send it to someone (excel doesnt copy summary bar) and this is not helpful when i want to do further calculations on it (subtract that sum from a total in another column)
if i sum one column in another column it does not return the sum of that column (which I could then do a further calculation on), only the current row. What is that?? That should be possible, without thinking about cells. A, then b, then it is a+b =
- lets say i have multiple months, and multiple contractors, how would i rollup everyones invoices by month and contractor? Am experimenting with it but no success yet