2 Replies Latest reply: Mar 15, 2018 10:24 AM by Digvijay Singh RSS

    Need Current Selection - 1

    Dan Coen

      Hi, I need an expression to take the current selection and minus one. For example, if Fiscal Year 2018 is selected, I need the expression to automatically - 1 to 2017. If 2016 is selected it would show 2015 etc.

       

      if(GetCurrentSelections([Fiscal - Year]),

      Sum({$<[Fiscal - Year]=GetCurrentSelections([Fiscal - Year]-1)>}

      [Amount - Shipped/Fulfilled USD]),

       

      This is what I tried, but its not working. Any assistance would be great