Deferred Revenue Waterfall Formula Help

Hi - I am trying to get a formula to properly allocated def revenue. What I have so far looks like it is working correctly in some instances but everything highlighted in yellow is incorrect. Bsically I need the "Greater than 12" column to calculate how much deferred revenue there is remaining and put that lump sum in the great than 12 column. For example on Row 12, I need it to allocate the MRR of 15,944 to each month until the def revenue amount hits zero and if it doesn't hit zzero before December, I want the lump sum remaining in def rev to go in the greater than 12 column.

Hopefully this makes sense.

Thank you so much!!

I want recognize deferred revenue based on the Fiscal year [ Column F row 2 to 5] irrespective of the calendar month.

Could anyone look into and help to correct formula
Urgent need help

Originally Posted by HansDouwe

I think Willem's formula in Post #2 does exactly what you asked for in Post #1.

Can you please help me to get that post