Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, try this:
Sum({<[Fiscal - Year]={$(=Max([Fiscal - Year])-1)}>}[Amount - Shipped/Fulfilled USD])
May be this -
if(GetSelectedCount([Fiscal - Year]),
Sum({$<[Fiscal - Year]={$(=Max([Fiscal - Year])-1)}>}[Amount - Shipped/Fulfilled USD]))