How do I multiply relative time values with previous time steps?

How do I?
1

I have this formula:

CustomersAdded[t]*CustomerRevenue[0] + CustomersAdded[t-1]*CustomerRevenue[1] + CustomersAdded[t-2]*CustomerRevenue[2]

CustomersAdded is a number, CustomerRevenue is a currency amount and is relative.

The idea is that I have an idea of the number of customers I’ll add per month, and then a projected cash flow for month 1, 2 etc

Is there a way of writing this formula so that I don’t have to repeat the t arithmetic? for every month (assuming I want to add more months to this projects cash).

2

Hi Ben, looks like you want to make use of the Spread function! See forum post here explaining how it works.

For your purposes the formula spread(CustomersAdded [0:t],CustomerRevenue [0:t]) should achieve your goal!

1 Like
3

I did see the spread function, but didn’t realise it worked like this :slight_smile:

What’s the difference between T and t here?

I’ll give this a shot, thanks @Sanjeev_Sandhar

4

Apologies - just a typo! No difference! Will amend.

1 Like