Sum up rows on external collection (Airtable)

Has anyone successfully and actually (as opposed to theoretically) summed up a series of rows on an Airtable table and output into a Text element?

I have a table of “sales” that has an amount. All I want to do is Sum the amounts.

It seems impossible (other than doing it on Airtable as a rollup)?

Perhaps this can help give you a little direction in solving this…

Yes, entirely possible on a internal collection.

Doesn’t work the same on an external collection however.

Maybe people need a cash incentive, as paying Adalo doesn’t seem to do anything. Never any support and they are so scared they close any thread that is critical of support.