9 Replies Latest reply: Jul 21, 2016 3:00 AM by Brijesh Fofadiya

# Expression Needed

Hi All,

I am having an logistic field and in that i have the data like,

a,

a others,

b,

b others,

c

c others.

Now i need to calculate only the fields are with others..

i.e. sum(if([logistic model] = 'aothers',if([logistic model]='bothers',if([logistic model]='c others'[lead count]))))

Thanks,

Bharat

• ###### Re: Expression Needed

May be like:

Sum(if( Wildmatch([logistic model], '*others*'), [lead count])

or,

Sum({<[logistic model]={ '*others*'}>} [lead count])

• ###### Re: Expression Needed

Hi Tresesco,

I have multiple others like d others,e others , h others.. but i needed onlysum of aothers,bothers,cothers not any others.

• ###### Re: Expression Needed

May be using single character wildcard '?', like:

Sum(if( Wildmatch([logistic model], '?others'), [lead count])

or,

Sum({<[logistic model]={ '?others'}>} [lead count])

• ###### Re: Expression Needed

Thanks a lot...

• ###### Re: Expression Needed

sum({<[logistical model]={'aothers','bothers','cothers'}>} [lead count])

• ###### Re: Expression Needed

thanks a lot

• ###### Re: Expression Needed

Hi

Try this

sum({<[logistic model] ={'*others'}>}[lead count])

• ###### Re: Expression Needed

Hi Bharat,

Try this,

sum({<T={'*Others*'}>}Value)

// Here, I took inline table for an example

E.g

Load * Inline

[

T, Value

A, 10

A Others, 45

B, 20

B Others, 40

];

Regards,

Brijesh

• ###### Re: Expression Needed

Hi Bharat,

Try this:

=count(if(WildMatch(A,'*others*'), A))

Regards philipp