3 Replies Latest reply: Sep 14, 2016 6:57 AM by Yeo Poh sai RSS

    How to add condition  SOURCE='TDSS' into sum(if(L5M='-1',sales/1000))

    Yeo Poh sai

      Hi All



      My expression below is working fine :-






      I like to add condition below into above expression :-






      sum(if(L5M='-1' & SOURCE='TDSS',sales/1000))



      I try the above , it return null value.



      Hope some one can help me.