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.
If I have a contract that last for 30 days:
Start date: 15 jan
end date: 15 Feb
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?
Thank you for your help
1 of 1 people found this helpful
Thank you, Lei, for kind words
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.