3 Replies Latest reply: Aug 13, 2014 7:47 AM by PAUL YEO RSS

    SET Expression does not able show amount for previous year ?

    PAUL YEO

      Hi All

       

       

      I have a Table , i am using below expression, is working fine :-

       

       

      sum({$<year = {$(=max(year) - $(=if(max(month) = 1, 1, 0)))}, month = {$(=num(month(addmonths(max(YearMonth), -1))))}>}  Invoice_Amt_SGD/1000)

       

       

      My issue is when the number increase to 7 , it display null :-

       

       

      sum({$<year = {$(=max(year) - $(=if(max(month) = 1, 1, 0)))}, month = {$(=num(month(addmonths(max(YearMonth), -7))))}>}  Invoice_Amt_SGD/1000)

       

       

      Can some one advise me how to check where it the error ?

       

       

      Paul