How to sum and get a total based on a specific date?

[ivan_campero]

Is there any way or formula to do this in appsheet?

[Suvrutt_Gurjar · Accepted solution]

Please take a look at the sample app below that has records selection based on user input and is principally similar to your requirement. You could further sum those selected records to get a sum.

https://www.appsheet.com/samples/Allow-the-user-to-filter-a-view-based-on-a-form?appGuidString=91266...

help.appsheet.com

Slices: The Essentials

Display only certain rows or columns of your table with slices.

help.appsheet.com

Slice Row Filter Conditions

Explore how to use row filter conditions to build different slices of data.

help.appsheet.com

SELECT()

Gather column values from row in table or slice

You could use a SUM() on the filtered records in teh slice.

help.appsheet.com

SUM()

Arithmetic sum of list items