4 Replies Latest reply on Jul 31, 2017 4:09 AM by kettan

# Revenue daily equal distribution by using start and end date of contract

Hello all,

I hope you can help me

I have a data set with a list of contract with a start and end date. I would need to allocate the revenue equally by day by using the start and end date attribute.

Example:

Contract one: 30,000

Start date: 01 Jan 2017

End date: 20 Feb 2018

I would like to distribute the 30,000 across the start and end date, most of the revenue will start in 2017 and only

• ###### 1. Re: Revenue daily equal distribution by using start and end date of contract

Hello Sandra,

Depends on the viz you expect to create, the solution might vary.

To simply calculate the average / per day, just try this.

However I don't think your requirement is as simple as this

Regards

Lei

• ###### 2. Re: Revenue daily equal distribution by using start and end date of contract

Thank you Lei Chen

My case is a bit more complex as I want the revenue to be recognised daily by using the start and end date.

Example:

If I have a contract that last for 30 days:

Start date: 15 jan

end date: 15 Feb

Cost:30K

I would like to see 15k recognised in Jan  - 15 K recognised in Feb and/or 1k recognised daily.

Do you know what formula should I build to get this information?

• ###### 3. Re: Revenue daily equal distribution by using start and end date of contract

Hello Sandra,

A great wiki by kettan for your reference.

Regards

Lei

1 of 1 people found this helpful
• ###### 4. Re: Revenue daily equal distribution by using start and end date of contract

Thank you, Lei, for kind words

OBS.

Split Periods Into Rows Dynamically  is just updated with an improved formula that reduces number of rows generated. See more about this improved method in the appendix at the bottom of mentioned document.

1 of 1 people found this helpful