Skip to main content

Hello,

Is there a formula that outputs cumulative average growth rates of a certain set of numbers? For example, an output of the last three months' revenues average growth rate could help model the rolling forecast (getting the trend is sometimes better than getting just the average).

Does that make sense?

Roy,
Melio

Hi Roy,

 

we don’t have a function that can do this precisely, but you can build this with several metrics and the MOVINGAVERAGE() function

 

 

3 Months Average formula is simply =

​​​​​​​ MOVINGAVERAGE(Revenue,3)

3 Months Growth =

 if(isblank(Revenue),blank,('3 Months Average'-RevenuenSelect:Month-3])/RevenueeSelect:Month-3])

Simply comparing the Average vs the revenue of 3 months back; but adding a check to not do it when we don’t have revenue yet

Forecast = 

if(isdefined(Revenue),Revenue,previous(Month)*(1+'3 Months Growth'tremove lastnonblank:Month]))

Translation: IF(there is actual revenue, we take revenue, previous value * (1+ last calculated growth rate)

 

Depending on your current app, you probably have a better way of doing the switchover (the check if the period is in the past vs future where we forecast).

 

I hope this helps !

 


Hi! Thanks for the fast response

 

This Really helps to get the concept of the best practice!

 

Thank you Nathan!


Reply