Classification calculation

[#1]

Hi all,

I'm confused about an issue.In the attached qvd file, you'll see there are "Gender__c" and "Hobby__c" fields.

For the value of "Gender__c" field is either "Female" or "Male", so I can calculate the corresponding records' total(as below):

But for the value of "Hobby__c" field is in the format of combination, just like:

So, if I want to calculate the records' total that "Hobby__c" is "Travel", how should I do ?

Thanks,

CoCo

[Anonymous]

Try:

Count(WildMatch(Hobby_c,'*Travel*'))

[jagan · Accepted solution]

Hi,

Try like this

Count({<Hobby__c={"Travel"}>} [Account Id])

OR

Count({<Hobby__c={"Travel, "}>} [Account Id])

OR

Count({<Hobby__c={"*Travel*"}>} [Account Id])

Replace Travel value with the value in your field.

Regards,

Jagan.

[#4]

Hi Jagan,

Thanks too much.

CoCo