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

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.

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