3 Replies Latest reply: Dec 21, 2017 10:15 PM by Yeo Poh sai RSS

    Create var vYn1 and replace 8 with $(vYn1) not working ?

    Yeo Poh sai

      Hi All


      I have Below expression , working fine :-


      money(

      sum({$<year = {$(=max(year)-8)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(ColumnDim51)/$(Columndim89)/1000)

      , $(vMoneyFormatK))



      Because , i need to reduce number of tab , i replace the 8 with variable. So i create vYn1 and set this var = 2009. and i replace the 8 with $(vYn1) :-


      money(

      sum({$<year = {$(=max(year)-$(vYn1))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(ColumnDim51)/$(Columndim89)/1000)

      , $(vMoneyFormatK))


      But it display null value. Can some one share with me why ?


      Paul