Apr 12, 2020 08:02 AM
Hello there is some way to totalize an entire column in another column or in a cell.
Thank you very much
Apr 12, 2020 10:05 AM
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!
Apr 12, 2020 03:11 PM
Perfect, that’s exactly how I need it,
Can you do me a favor and explain how to do it?
Thank you
Apr 12, 2020 03:14 PM
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.
Apr 12, 2020 03:26 PM
Thank you very much for your help.