Skip to main content
2 Antworten
  1. 7. Nov. 2024, 11:49

    Video's and pages aside @Diksha Joshi​, as Caleb has explained, these are really window calcs. For example:

    Window_Avg(Sum(Sales),0,-4)

    Will perform a running sum (cumulative) for the last 4 periods in your data.

    But in order to perform a difference calc against another period, you'll need to change the summation vectors with a new calc:

    (Window_Avg(Sum(Sales),0,-4) - Window_Avg(Sum(Sales),-4,-8)) / Window_Avg(Sum(Sales),-4,-8)

    Should do it.

    Steve

0/9000