Does anyone know how to do a running total?
In Excel it would be easy: Prior Result + new Result = Running Total thus far
But I can’t figure it out in Coda.
I need this so that I can calculate the payback period on a customer.
E.g. A customer costs $3,000 to acquire and they are paying a variable amount per month (based on usage of their product). I want to show that, for example, at Month 3 we’ve made our money back. Anyone have an idea how to do this?
A workaround that I’m currently using is showing the average payback period. I do this by dividing Cost of Acquisition by the average of the Profit column. But this has obvious deficiencies.
For example if someone’s usage skyrockets late in the year, it skews the average to make it seem like we were profitable much sooner than we were.
cost of acquisition = $10,000
Average payback period = 2 months
Actual payback period = 5 months
An ability to do a running total is vital in this case. Would love any advice someone has.