Does SET expression allow user select yr=2016 and mth =12 and still able to display value ?

[paulyeo11]

Hi All

My Table have below expression display YTD sales work fine  :-

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

And below display YTD LY sales :-

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

My question is when user need to compare whole year 2015 vs 2016 from Jan till june sales , user click on year=2016 and month = 12

the table display null value.

May i know how to make it display YTD sales amount for both column ?

Paul

[PrashantSangle]

Hi,

It must work . Try below

Sum({$<year = {$(=Max(year)-1)}, month = {"<=12"}>}sales/Rate)

or

Sum({$<year = {$(=Max(year)-1)}, month = >}sales/Rate)

Regards

[paulyeo11]

Hi Max

Sure I will try, thank you for so confident in yr expression. As now I take a break for my dinner.

Sent from my iPhone

[paulyeo11]

Hi Max

I just test , it work fine.

Thank you

Paul