Skip to main content

Hi!

 

I have a Start date, an End date and a Revenue number. I'd like to be able to split the revenue number equally over the months between the start date and end date for each Order. For example:

 

Order: 1

Start date = '2017-06-06'

End date = '2017-12-04'

Revenue = 28,000

 

Jun: 4000

July: 4000

Aug: 4000

Sep: 4000

Oct: 4000

Nov: 4000

Dec: 4000

 

Thanks!

1 answer
0/9000