Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to use Layout>Show>Conditional to show only field names in the list box with OCO in the string.
I tryed GetfieldSeletions([ABC]) like '*OCO*' but that means I have to select I just want to exclude everying without OCO in the field
How can do this?
Expression:
if(index(MyField,'OCO')>0,MyField)
Ok i tried this and it works
=if([MARKET RISK: NOTE: on target + overdue = LIVE ISSUES] LIKE '*OHL*',[MARKET RISK: NOTE: on target + overdue = LIVE ISSUES])
Then how can I automatically select them as they will be in a 'state'
Thanks
Sorry OCO was wrapped in a wildcard *OCO*