Need help for display SUM (total) of a Airtable column in a label

Hi Guys,
how do i display the total of a “Amount” column from Airtable.

i try this

but it shows like this 50020005000, it should show 7500 instate of 50020005000.

How should I do this?
Thanks😉

That’s because your Airtable column has text values so Thunkable can’t find a “sum” for them and it just joins them instead. Make the values numbers and try again. You can also sum the values in Airtable in a different column and just get that single value from Airtable in Thunkable. That’s faster.

I am unable to sum the values in a different column in Airtable. The Excel formula doesn’t work in Airtable, and I can’t figure out how to sum the values in a separate column.

That should be pretty easy to figure out. Google airtable sum column or ask ChatGPT or another LLM.

I’ve been searching for the past 3 to 4 hours, but I couldn’t find anything about how to sum the values in a separate column in Airtable​:sweat::sweat: