3 Replies Latest reply: May 29, 2017 6:36 PM by Yeo Poh sai RSS

    Set expression how to add one more condition ?

    Yeo Poh sai

      Hi All



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




      DO filed :-




      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.