Skip to main content

how do i total a column

  • April 12, 2020
  • 5 replies
  • 43 views

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

5 replies

Forum|alt.badge.img+19
  • Inspiring
  • 323 replies
  • April 12, 2020

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!


  • Author
  • New Participant
  • 2 replies
  • April 12, 2020

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!


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


Forum|alt.badge.img+19
  • Inspiring
  • 323 replies
  • April 12, 2020

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.


  • Author
  • New Participant
  • 2 replies
  • April 12, 2020

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.


Thank you very much for your help.


Forum|alt.badge.img+12
  • Inspiring
  • 24 replies
  • November 14, 2024

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