First the forum page is not opening for me from my laptop (different ips and different browsers) works only from mobile - is it only me or someone else has this ?

Now my question is what’s the best way to calculate the sum of certain fields In a repeating group , lets say the type contains a field total amount and there are 100 records in the database. How to calculate the sum of all total amounts ? I guess it can be done by converting the search result into a list? But then there is a limit of 1000 records.
Please advise

Ok i found a way to calculate the sum with math.js - see a screenshot below, but it takes a few seconds to do the math even for a few records, I imaging that it would be difficult for large operations. Isn’t it possible to implement these math operations through “calculate formula” function in Bubble?

I"m mostly using the :sum operation which is built in Bubble. for that first you do a search for the a certain type, then a certain field which has a filedtype - number, and then you can add :sum to the end of that search and it will sum up all those fields together.

Can you help me with this please? I’m having the same issue, but I didnt understand the answer. I want the total of prices in a repeating group. When I do the search for, this is all I get

Hello. Great that you did well with calculating the sum of fields in a repeating group (RG). Could you pls tell me how to handle it:

which field type I must asign to the fields in RG so that I can make a sum?

At the moment I use text elements for such fields to display the number. Do I have to replace that Text elements by Input Elements for this purpose?
Thanks