1 Reply Latest reply: Jun 7, 2017 7:46 PM by Taj Mohamed RSS

    Need to create a rolling 4 months based on Variabel

    Dan Coen

      Hi, I need to create a chart that shows a rolling 4 months. However, I am having an issue which I believe is syntax related.

       

      I created a variable which always shows the current fiscal quarter ID, which is currently 71(variable is vCurrentFiscalQuarterId). I want to use set analysis to show the current shipment amounts for each quarter prior to the current one going back one at a time. However, I am having an issue with the set analysis below as it returns null results.

       

      Sum({$<

      [Fiscal - Quarter Id]={'=(($(vCurrentFiscalQuarterId)-1)'}

      >}[Amount - Shipped/Fulfilled USD])

       

      Any help would be great.

       

      Thanks!