Searching for an item which has a carriage return

[ZoeM]

Hi Community.

I have a field which has values with carriage return and I am trying to build a set analysis expression that will search for specific strings in the filed and I cannot seem to get it to work.

Any Ideas? In the below, the field "Main Causal Factor" contains string values that have carriage return i.e. "Late Issue

Resolution"

Count({$<[#of Days Post VPP]={'>14'},[Date Type]={'VPP Dates'},[Main Causal Factor]={'Late Issue

Resolution'}>}[Gateways])/Count(TOTAL{$<[Main Causal Factor]=-{' '},[Date Type]={'VPP Dates'}>}[Gateways])

Thanks for any help rendered.

[sunny_talwar · Accepted solution]

How about if you do this

Count({$<[#of Days Post VPP] = {'>14'}, [Date Type] = {'VPP Dates'}, [Main Causal Factor] = {'Late*Issue*Resolution'}>} [Gateways])/Count(TOTAL{$<[Main Causal Factor] = -{' '}, [Date Type] = {'VPP Dates'}>} [Gateways])

[ZoeM]

Thanks Sunny, works like a charm