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

PrevContributor
PrevContributor
in Modeling

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

Tagged:

Best Answer

  • PrevContributor
    PrevContributor
    Answer ✓
    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.

Categories