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!
