1 Reply Latest reply: Mar 14, 2016 11:28 PM by PAUL YEO RSS

    Why RATE_C must move out side the expression ?

    PAUL YEO

      Hi All

       

       

       

       

      I have 1 expression 1 return wrong value  :-

       

       

      sum({$<year = {$(=max(year)-0)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}(sales)/1000)

      *RATE_C

       

       

      Below expression i move RATE_C out side , it return right value :-

       

       

      sum({$<year = {$(=max(year)-0)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}(sales*RATE_C)/1000)

       

       

      May i know why ?

       

       

      Paul