3 Replies Latest reply: Apr 2, 2012 11:05 AM by Chris Hopkins RSS

    Help with expression

    Chris Hopkins

      Hi everyone,


      Can you tell me if the following expression is correct please?


      sum(if(wildmatch(Narrative,'STKADJ*'>0 or Narrative,'GRN*')>0,StockValue))



      I need it to give me a figure of the StockValue for anything where the Narrative is wildmatched to STKADJ and GRN.