how do i total a column

[Edwin_Alberto_O]

Hello there is some way to totalize an entire column in another column or in a cell.
Thank you very much

[andywingrave]

Hey there! This is a great question, and actually requires a little workaround, which basicalically involves you creating a new table, and using the lookup field.

I’ve created one here for you:

As you can see, I created a record called “sum” and applied that to all of the records. So now I can use that value elsewhere.

Hope that helps!

[Edwin_Alberto_O]

Perfect, that’s exactly how I need it,
Can you do me a favor and explain how to do it?
Thank you

[andywingrave]

If you look at the hidden field, you can see a “SUM” Linked Field. Which I’ve added and linkedall to a running totals table.

Then I’ve done a lookup of the SUM again in the totals field.

There’s a support article out there on this too, I think, as I remember that’s how I learned about this workaround.

[Edwin_Alberto_O]

Thank you very much for your help.

[LaurenMaine]

Hi, @andywingrave is that file still available? I'd love to see how to do this...