I need to phased income over time over period (example below)... any suggestion how I can do that please?
Income per month line is where I want to get to!!
Thanks in advance
Go to Solution.
Hi @Will Man
Look at "Spread" function
View solution in original post
You could make use of the CUMULATE function or YEARTODATE funtion or MOVINGSUM function.
I would recommend YEARTODATE function.
Also, look at PROFILE
This sounds like a similar problem I solved with "cohort" or "diagonal" calcs.
See this post from earlier this year
Hope that helps
@DavidSmith It's very intersting solution with fake time dimension.
In case of small number of periods to spread (less then 10) as an alternative one we can use another way:
Add up to 10 slave line Items with formula like:
'Period+1'= OFFSET(inputdata,-1,0)* '% for day1'
'Period+2' = OFFSET(inputdata,-2,0)* '% for day2' etc.
Total = 'Period+1'+ 'Period+2' etc.
This solution sometimes can be faster and take less cell quantity.
But "It depends" on the model and not a rule