Register

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!!

 Income 100 200 150 Jan Feb Mar Apr May Jun Jul 1 20 40 30 2 20 40 30 3 20 40 30 4 20 40 30 5 20 40 30 Income per month 20 60 90 90 90 70 30
5 REPLIES 5
Master Anaplanner/Community Boss

## Re: Phased an income over period

Master Anaplanner/Community Boss

## Re: Phased an income over period

Certified Master Anaplanner

## Re: Phased an income over period

Master Anaplanner/Community Boss

## Re: Phased an income over period

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

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.