6 Replies Latest reply: Jul 17, 2016 9:58 AM by PAUL YEO RSS

    How to add SEGMENT ~= [Related Coy] into sum(if(L5M='-1',sales/1000)) ?

    PAUL YEO

      HI ALL

       

       

      I want to remove row , when SEGMENT field = Related Coy.

       

       

      So i need to insert SEGMENT ~= [Related Coy] into below expression :-

       

       

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

       

       

      I imagine the expression should be :-

       

       

      sum(if(L5M='-1',SEGMENT ~= [Related Coy],sales/1000))

       

       

      But it cannot work.

       

       

      Paul