Multiple text search in set analysis

[udaya_kumar]

Hi,

I have a field Role with values like

Tele India - Agent

Tele India - manager

SIT India - Manager

SIT India - Agent

Tele India Bangalore - Agent

..................

Here i want to sum the values in set analysis for only values where

Role is having India and Agent both

I have written exp like this

sum( {$<ROLE= {" *India* "}>} Value) - This will search for the rows which is having India in the Role field

But i want to have India and Agent both in the same row in the field ROLE.

How can i search for multiple values in set analysis? (It should work as "And" condition as the row should have both India and Agent)

[Anil_Babu_Samineni]

May be this?

Load *, SubField(ROLE, ' ', 2) as ROLE_Country;

and expression should this?

Sum({<ROLE_Country = {'India'}>} Value)

[udaya_kumar]

Hi Anil,

Thanks for the reply.

I want to have search for both India and Agent in ROLE field, not only India.

And i want it in set analysis.

[Anil_Babu_Samineni]

First you need to split into different variations and can be achieve same

[tresesco · Accepted solution]

May be like this?

sum( {$<ROLE= {"*India*Agent*"}>} Value)

Or

sum( {$<ROLE= {"*India*"}>*<ROLE= {"*Agent*"}>} Value)

[udaya_kumar]

Thank you very much Tresesco.