Contributor

## How to calculate Month to month Growth Rate?

Hi all!

What is the way to calculate Month to Month Growth rate (from the beginning of the time scale)

if I have Sales Volume by month at monthly timescale?

I have:

(Volume by Month - PREVIOUS (Volume by Month)) /PREVIOUS (Volume by Month)* 100%

I wrote the formula but it doesn't match the math result (when I'm making calculation check)

Thank you.

12 REPLIES 12
Community Boss

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
HeathcoteAndHerran.com
Community Boss

Hi @JoannaAn ,

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

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

Thanks

Akhtar

Contributor

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 @ChrisAHeathcote

I very much appreciate community help! 😃

Joanna.