Help

Displaying cumulative sums

Topic Labels: Formulas
Solved
Jump to Solution
1505 1
cancel
Showing results for 
Search instead for 
Did you mean: 
bartdubs
4 - Data Explorer
4 - Data Explorer

bartdubs_0-1691698310409.png

How would I display the sum of this column and make it such that every time a new record was added the sum is updated with the new information so that it is usable information on softr?

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

I think you'll need to create another table called "Rollup" or something and make sure to link all the records you want to sum up to a single record in that "Rollup" table

Then, you'd create a rollup field with "SUM(values)" to sum everything together

Finally, create an automation that'll automatically link any newly created record to that one record in the "Rollup" table and it should update as expected

See Solution in Thread

1 Reply 1
TheTimeSavingCo
18 - Pluto
18 - Pluto

I think you'll need to create another table called "Rollup" or something and make sure to link all the records you want to sum up to a single record in that "Rollup" table

Then, you'd create a rollup field with "SUM(values)" to sum everything together

Finally, create an automation that'll automatically link any newly created record to that one record in the "Rollup" table and it should update as expected