?

[xyz1]

.

[prma7799 · Accepted solution]

Try like this

sum(if( "market"='DOMESTIC', if(not WildMatch( party_name ,'ALEX*' ), (basicvalue))))

[tresesco]

Try like:

sum({<market={'DOMESTIC'}, party_name - ={'ALEX*'} >} basicvalue)

[prma7799]

or try

sum(if(not WildMatch( party_name ,'ALEX*' )  and "market"='DOMESTIC' ,basicvalue))