need to select only 4 values out out of 10 by using sey analysis

[#1]

I am using this one

=sum({$<[branch]={'e'}>} [Amount])

for example I am having a field name calles branch

branch

e

r

p

w

q

v

g

j

from these i need only e r w q to be selected i am having expression for selecting one value but to select 4 values i am unable to do it please help

[Anonymous]

=sum({$<[branch]={'e','r','w','q'}>} [Amount])

[#3]

i am using it I am getting 0 as answer

sum({<[Account String]={'.2001.','.3072.','.3023.','.3034.'}>} [Money])

actually the string goes as 10.01.2001.4567

from that tha middle numbers i am selecting

[Anonymous · Accepted solution]

Not sure what you mean...  Are you looking for the substrings of the Account String?  If yes, try this:

sum({<[Account String]={'*2001*','*3072*','*3023*','*3034*'}>} [Money])

[eddysanchez]

Fot the selection:

sum({<[Account String]={'*.2001.*','*.3072.*','*.3023.*','*.3034.*'}>} [Money])

For All:

sum({1<[Account String]={'*.2001.*','*.3072.*','*.3023.*','*.3034.*'}>} [Money])