12 Replies Latest reply: Jun 23, 2016 7:36 AM by PAUL YEO RSS

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

    PAUL YEO

      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