11 Replies Latest reply on Jun 19, 2019 11:39 AM by Deepak Rai

    TTM Calculations

    Jodi Hargreaves
    Jodi Hargreaves Jun 19, 2019 9:07 AM

      Hi there,

       

      On one sheet I have a generic listing of year and month with assets.  I have created a TTM average calculation as follows:

      RUNNING_SUM(sum([Assets]))-ZN(lookup(RUNNING_sum(sum([Assets])),-13))/13

       

      The above formula works great.

       

      On another tab, I am trying to create a summarized version that does not show the year/month in the table, but instead has month as a filter item.  I would like to return the exact same TTM average from the previous sheet on the new one.

       

      For Example if on Sheet 1 have

       

      Year   Month       Assets     TTM aver

      2018    3              707          688

      2018     4             709          691

      2018     5             717          694

      2018     6             724          697

      2018     7             730            702

      2018     8             733           707

      2018     9             726            712

      2018    10            694             713

      2018    11            700            713

      2018    12            672             711

      2019     1             698            710

      2019     2            713              712

      2019     3            740               714

       

       

      on the next sheet I have

      year     month     TTM average

      2019   3          XXXX

       

      I need to figure out a way to pick up the 714 on the previous sheet to put here.  Any ideas?  The date fields are generic, i.e. there is no January 31, 2019, just month 1, year 2019

       

      Thanks so much in advance for any help.