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

[PrevContributor]

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

[PrevContributor · Accepted solution]

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.