Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a problem with set analysis that i am hoping for an answer
I am using this expression and it works
=
count( {1<Siccode= {Construction} >} CaseID )
This counts all Siccodes that are text string construction only.
I want to replace the string Construction with the selected Siccode in a list box
I have tried
=
count( {1<Siccode= {Siccode} >} CaseID )
As I have selected company in another list box the Siccode is filtered but not selected.
Thanks for your help
Syntax would be something like: count( {1<Siccode= {$(=Only(Siccode))} >} CaseID )
Can users only select one Siccode? If so, try using only(Siccode)
Syntax would be something like: count( {1<Siccode= {$(=Only(Siccode))} >} CaseID )
Thanks Paul worked a treat