How to add more condition especially contains in count expression

[saivina2920]

I have to apply contains along with more condition in the below expressions.

=Count({<[TO]={'BRITTA-DEALER'},[FROM]={"$(vManufacturer)"}>} DISTINCT [ORDER_ID_NUMBER])

1. i want to get  [TO] contains {'BRITTA'} only instaed of [TO]={'BRITTA-DEALER'}

2. i want to add one more condition like [Status]='NEW' along with the above expression.

How to modify the above expressions along with above two points.

pls.help..

[saivina2920]

Anyone can help us to proceed further....

[tresesco]

@saivina2920 This?

=Count({<[TO]={'BRITTA'},[Status]={'NEW'},[FROM]={"$(vManufacturer)"}>} DISTINCT [ORDER_ID_NUMBER])

[saivina2920]

Thanks for your reply.

[TO] should not be hard coded like ['BRITTA']

Because  column "TO" fetch all the record which contains "BRITTA"

  {'BRITTA-DEALER'}

  {'BRITTA-SHOPPER'}

  {'BRITTA-AGENCY'}

  {'BRITTA-REGION'}

 etc....

[saivina2920]

if need any more details pls. let me know.

[saivina2920 · Accepted solution]

For contains, i used below and it's working.

[TO]={'*BRITTA*'}

=Count({<[TO]={'*BRITTA*'},[Status]={'NEW'},[FROM]={"$(vManufacturer)"}>} DISTINCT [ORDER_ID_NUMBER])