Phased an income over period

Highlighted
New Contributor

Phased an income over period

Hi 

 

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

 

Income100200150    
        
 JanFebMarAprMayJunJul
1204030    
2 204030   
3  204030  
4   204030 
5    204030
Income per month20609090907030
5 REPLIES 5
Highlighted
Master Anaplanner/Community Boss

Re: Phased an income over period

Highlighted
Master Anaplanner/Community Boss

Re: Phased an income over period

Highlighted
Certified Master Anaplanner

Re: Phased an income over period

Highlighted
Master Anaplanner/Community Boss

Re: Phased an income over period

@Will Man 

This sounds like a similar problem I solved with "cohort" or "diagonal" calcs.

See this post from earlier this year

https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Diagonal-sums-over-flat-list-dimension...

 

Hope that helps

David

Highlighted
Certified Master Anaplanner

Re: Phased an income over period

@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

 

Dmitrii Mamaev.