How to calculate Month to month Growth Rate?

ChrisHeathcote
Community Boss

Re: How to calculate Month to month Growth Rate?

@JoannaAn 

Break the formula out over several line items.

Volumes 

Prior Volumes 

Growth

You can also use an IF THEN ELSE statement to populate month 1 for Prior Volumes

=IF PREVIOUS(Volumes) <> 0  THEN PREVIOUS(Volumes) ELSE Volumes

This makes the assumption that this is the first month so closing volumes equal closing volumes. It Also assumes that every other month with have volumes greater than zero. If this is not the case then use @JaredDolich method of populating month 1.

Also, remove the * 100% and simply format the line item as a % in the blueprint.

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
Akhtar.shahbaz
Community Boss

Re: How to calculate Month to month Growth Rate?

Hi @JoannaAn ,

 

Based on your table, i have done the below calculation.

Screenshot_47.png

Screenshot_48.png

 

Add the logic if you want last month volume to be populated in the first months @JaredDolich  mentioned

 

Thanks

Akhtar

View solution in original post

JoannaAn
Contributor

Re: How to calculate Month to month Growth Rate?

Oh! Thank you @Akhtar.shahbaz

For now I only tried ratio, and Ratio didn't work for me for some reason...

 

And to make the Line item for the Previous months worked for me well.

(and it also allowed me to change sum - to formula that I couldn't do before)

I see now what @JaredDolich meant ...

 

Thanks to you,

and also to @JaredDolich  and @ChrisHeathcote 

I very much appreciate community help! 😃

 

Joanna.