I’m fairly new to Fibery but it seems like exactly what I’ve been looking for Thank you everyone for everything you’ve done!!!
I’ve created a few formulas and I’m figuring Fibery out, but there’s one that I can’t crack - and when I search the “community” here, I can’t find it either.
One of the uses of Fibery I want to use is to keep track of all our financial transactions for our little non-profit. As part of that, I’m making a “Space” in which one “Database” is just a list of all our transactions (all money donated, and all money spent, with a timestamp for each.)
I basically want to have a field that is just a running tally of how much money for each row, based on the sum of all previous “donation” fields (up until and including that entry), subtracting all previous expenses from the “expenses” field (up to and including that entry).
The Excel equivalent to this is just the classic column where you add in the previous row’s number to a running total. Basically “first day of excel” haha.
As an example, if on the oldest date (first row, oldest timestamp), we have that the “donation” field got $10 in donations, and then in the second row (for the second-oldest timestamp) has in the “expenses” field an expense of $6… then, for the most recent of the two entries (the second one, with the $6 expense), the running tally field should say that we currently have $4 in our running balance.
I feel like in Fibery, this is probably done with “RunningSum” - but I can’t seem to crack the formula.
I’d love any leads or any help.
Thank you so much
PS – In trying different formulas to try to figure out how to do this, I’m trying this formula to sum up all the transactions up until that point of that row:
[Dollars Received].Filter(Date <= [This TransactionsTracker].Date).Sum()
But it returns an error: Cannot call “Filter” method – but I can’t understand why.