Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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])
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])
Thanks Sunny, works like a charm