PY Calculation when Year filter is selected

[laura_1]

Hi, 

Is there a way to calculate PY values when a value is selected in year filter? 

Let's assume we have the following values:

Year, Sales

2019, 50

2018, 40

2017, 20

If I select 2019 in the year filter, sum ({<Year={"$(=max(Year))"}>} sales) returns current year (2019) values, but calculation for PY sum ({<Year={"$(=max(Year))-1"}>} sales) returns zero.

[dplr-rn]

your -1 is not inside the dollar sign expansion

sum ({<Year={"$(=max(Year))-1"}>} sales) 

change to below

sum ({<Year={"$(=max(Year)-1)"}>} sales) 

[laura_1]

Thanks for your quick reply but it still returns zero..

[dplr-rn · Accepted solution]

thats odd. 

i checked below in my local app and it works.

sum ({<Year={"$(=max(Year)-1)"}>} LineSalesAmount)

which version of sense are you on.  newer versions give an output preview of the dollar sign expansion. see below. check that

[laura_1]

Checked again and it worked, thanks very much for your help 🙂 

[dplr-rn]

Great. Mark as answered to close the thread