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.

       

      Thanks