p() in set analysis

[jduluc12]

HI,

I want to write an expression to include amount only for those customer whose name starts with "ABC" but does not have address which starts with "XYZ"

sum({<Customer=p{1<Name={'ABC*'}, Address={'*'} - {'XYZ'}>Customer}>}Amount)

it is not working and it behaves exactly like as if the statetment is

sum({<Customer=p{<Name={'ABC*'}>Customer}>}Amount)

what am i doing wrong?

Thanks

[effinty2112]

Maybe:

sum({$<Customer = {'ABC*'}>*<Address -={XYZ*}>}Amount)

Good luck

Andrew