Sum values by date

Question

Hello all, hope everyone's okay!

Today i got a problem and hope someone can help me with that.

I have an database with some values separated by client and date (Like, Bob  |  2500  |  01-01-2022), but my value field should be the sum of his whole debt until that month, so i would like to know how to sum the value of each one of the date with the last months

Something like this

ShankerV · Answer

Hi @TormentMaker

The best tool to get the solution is Running total tool.

Note: Use Group By on Name

Many thanks

Shanker V

Felipe_Ribeir0 · Answer

Hi @TormentMaker

Another way of doing this:

davidskaife · Answer

Hi @TormentMaker

The Running Total tool will do this for you with ease:

Simply group by Name and create running total on value:

Running Total.yxmd