Expression Needed

[bharatkishore]

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

[tresesco]

May be like:

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

or,

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

[er_mohit]

Hi

Try this

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

[bharatkishore]

Hi Tresesco,

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

[#5]

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

[tresesco]

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

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

or,

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

[philipp_ebner]

Hi Bharat,

Try this:

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

Regards philipp

[#8 · Accepted solution]

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

[bharatkishore]

Thanks a lot...

[bharatkishore]

thanks a lot