Help with expression

[hopkinsc]

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

[CELAMBARASAN]

Hi,

     Change it to

     sum(if(wildmatch(Narrative,'STKADJ*') or wildMatch( Narrative,'GRN*'),Sum(StockValue)))

Celambarasan

[swuehl · Accepted solution]

If I understood correctly:

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

[hopkinsc]

Thanks for that. It didn't quite work but i changed it to

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

Which worked.

Thanks

Hi Stefan,

Thanks that also worked and is easier to understand.

Thanks