3 Replies Latest reply: Sep 14, 2016 6:57 AM by PAUL YEO RSS

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

    PAUL YEO

      Hi All

       

       

      My expression below is working fine :-

       

       

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

       

       

      I like to add condition below into above expression :-

       

       

      SOURCE='TDSS'

       

       

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

       

       

      I try the above , it return null value.

       

       

      Hope some one can help me.

       

       

      Paul