Cashflow Calculation Table

Hi Community,

Once again I turn to you for help
I’m trying to have a table that shows a project cashflow in a simple way (Cash In vs. Cash Out)
I need to have an accumulated column to calculate the total Cash In based on Project and Starting from the smallest month to the largest month
I have created a demo page below with a manually accumulated column to explain what is needed. I need to do this with a formula and no matter what I try, I’m not able to reach the result that I need

Hoping for your help

Thank you in advance

image

Where the first item of all the filter elements is CurrentValue.column and the second item is thisRow.column

It is not the most efficient programming, but up to a couple of thousand rows it will do the job.

I added a column in your doc to show that this works:

…and manual mistakes are a thing of the past:

5 Likes

Thank you so much, that works perfectly…

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.