15 Replies Latest reply: Apr 12, 2016 11:58 PM by Sunny Talwar RSS

    How to replace getselectcount(year) with year = {$(=Max(year)-1)} ?

    PAUL YEO

      Hi All

       

      My below expression work fine :-

       

      Sum({<year = {$(=Max(if(getselectedcount(year)=0,2015,year))-0)} , month = {"<=$(=Max({<year={$(=Max(if(getselectedcount(year)=0,2015,year)))}, sales = {'*'}>} month))"}, cOST={"cOST"} >} Amount*-1)/Rate/1000

       

      To reduce maintenance , i like to change to using :-

       

      year = {$(=Max(year)-1)}

       

      Paul