Returning specific values

Post Author: Nick7

CA Forum: General

I have a report that returns value's only if they contain data in a notes field (StockBatch.Notes is not equal to blank). Is it possible to specify this even further and return notes that only include certain words? My report is intended to show all product batches that have been marked as damaged, but other notes are used also. These I don't want, just the damaged items. I looked at a formula using the LooksLike function, but this did not solve the problem. I also tried various things in Select Expert without success, so any ideas would be great.

Thanks