2 Replies Latest reply on Jul 20, 2018 12:14 PM by Eric Pynnonen

    Sum of row-level differences over time

    Eric Pynnonen

      I’m trying to track the volatility of a certain type of issue by adding up the absolute values of the differences, across all items with issues, then displaying the sums of the differences over time. The calc I came up with:

       

      {INCLUDE [Item #]:

      SUM(ABS([# of Problems] – LOOKUP([# of Problems],-1)))

      }

       

      Of course this can’t work, since table calcs can’t go inside LOD expressions. Is there a simple solution I’m missing?

       

      I have thousands of [Item #], and several dozen daily dumps of their [# of Problems] all UNIONed together to create the over-time dataset.