6 Replies Latest reply on Feb 14, 2018 3:08 PM by Jim Dehner

    Calculate rolling LTM using DATEDIFF to work in a table

    Anders Fagerholt

      Hi all,

       

      New to the forum. Thanks for helping.

       

      I want to calculate Customer Base Value as the current month's CMRR plus the sum of Transaction revenue LTM minus the sum of COGS LTM. See screenshot below.

       

      I have read other forum entries like this one, but I can't find any way to have the LTM value dynamically calculated as a field in a table.

       

      I need to know the Transaction LTM for all months (so in March 2017, the sum of Transaction from April 2016 through March 2017).

       

      Is this possible?

       

      Attached an attempt in the sample workbook below.

       

      Thanks!

      Forum - Customer Base Value.png