6 Replies Latest reply: Jul 17, 2016 9:58 AM by Yeo Poh sai RSS

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

    Yeo Poh sai

      HI ALL



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



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






      I imagine the expression should be :-



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



      But it cannot work.