3 Replies Latest reply on Nov 26, 2018 5:08 AM by Yuriy Fal

    Running Sum should get zero to the month where there is zero value in that month

    Yogish b



      I have scenario where i have to show running sum total on the trend for each month.

      I used below calculation where i got the correct numbers till where there is data. But i'm getting the Sep month value for the next three months where the data is zero in Oct, Nov& Dec)

      RUNNING_SUM(sum(if [Scenario]='Actual' then [Numerator] END)) / RUNNING_SUM(sum(if [Scenario]='Actual' then [Denominator] END))


      all i want is running sum should become zero for last 3 months where i should not use filter on month dimension.


      Appreciate quick help on this scenario.