7 Replies Latest reply: Dec 10, 2017 5:14 PM by Rakesh Shah RSS

    Stopping rangesum showing after a given date

    Rakesh Shah

      Hi

       

      I am using rangesum function to plot Forecast vs Actuals along the same date line. When i run the Actual sum range, it works by restricting the date based on the set analysis (see formula below). However I want to also show forecast numbers for the next couple of weeks after the actuals have ended (ie "today"). When I do this it shows the actuals as a flat line across those dates (see image). Is there a way to stop the actuals showing for dates "after today"

       

      Actual: rangesum(above( sum({<[Date]={"<$(Today())"}>}[Actual_deployment]),0,rowno()))

      Forecast vs Actuals.PNG

      thanks in advance

       

      Rakesh