6 Replies Latest reply: Feb 4, 2018 5:35 PM by Yeo Poh sai RSS

    How to add one more condition expression ?

    Yeo Poh sai

      Hi All


      Below is the expression work fine :-

      sum(Amt_$K)


      I need to add 2 more below condition :-


      Year_V=2018


      Status_V=Open


      I try :-


      sum(if(Year_V=2018,(Amt_$K)))


      it work fine , then i add one more condition :-


      sum(if(Year_V=2018, Status_V="Open",(Amt_$K)))


      it return not correct value.


      Paul