3 Replies Latest reply: May 29, 2017 6:36 PM by PAUL YEO RSS

    Set expression how to add one more condition ?

    PAUL YEO

      Hi All

       

       

      sum({$<month-={$(=Num(Month(AddMonths(Today(),-2))))}>} [TOTAL_AMT])/1

       

       

       

      DO filed :-

      NOT_INVOICE

      Reserve

       

      Now i like to add condition DO=NOT_INOVICE into above expression.

       

      I try :-

       

       

      sum({$<month-={$(=Num(Month(AddMonths(Today(),DO=NOT_INVOICE,-2))))}>} [TOTAL_AMT])/1

       

       

      If the above expression is correct , the value display with be same as column 2 Correct column.

       

      Hope some one can advise me.

       

      Paul