How to calculate Year to date (YTD) Growth rate?

Highlighted
Previous Contributor

How to calculate Year to date (YTD) Growth rate?

Hi, I have build a forecast model and need to show the Year-to-Date growth rate. Is there a systematic way of doing it? Regards, Atyagi

1 REPLY 1
Highlighted
Previous Contributor

RE: How to calculate Year to date (YTD) Growth rate?

Jill King: The following formula would work to do annual YTD cumulations where VALUE2 is the item you want to cumulate and you are using a monthly timescale: CUMULATE('VALUE2') - OFFSET(CUMULATE('VALUE2'), -MONTH(START()), 0) I found this in another thread. its helpful and solves my problem.