Set Analysis using E() function.

[#1]

Hi!

I have the following Set Analysis expression:

sum({$<Table={'ResultStates'}, CodEERR = {'RNO'},MovType={'Real'}>}January)

- sum({$<Table={'ResultStates'}, CodEERR = {'RNO'},MovType={'Real'}, Account={2602}, SubAccount={'015'}, Business={'Oil'}>}January)

- sum({$<Table={'ResultStates'}, CodEERR = {'RNO'},MovType={'Real'}, Account={2602}, SubAccount={'017'}>}January)

- sum({$<Table={'ResultStates'}, CodEERR = {'RNO'},MovType={'Real'}, Account={2601}, SubAccount={'002','008','009','007','012','013','014'}>}January)

I need to translate it, using E() function. I have tried the following:

sum({$<Table={'ResultStates'} ,CodEERR = {'RNO'} ,MovType={'Real'}

,Account=E({1

     <Account={2602}, SubAccount={'015'},Business={'Oil'}>

     +<Account={2602}, SubAccount={'017'}>

     +<Account={2601}, SubAccount={'002','008','009','007','012','013','014'}>})

>}January)

since I want the word 'January' to appear just once. Of course, I'm a here and thus it means that my attempt does not work : (

Could someone lend me a hand?

Thanks!

[#2]

I just ended up using the exclusion sign:

sum({$<Table={'ResultStates'}, CodEERR = {'RNO'},MovType={'Real'}>

- <Table={'ResultStates'}, CodEERR = {'RNO'},MovType={'Real'}, Account={2602}, SubAccount={'015'}, Business={'Oil'}>

- <Table={'ResultStates'}, CodEERR = {'RNO'},MovType={'Real'}, Account={2602}, SubAccount={'017'}>

- <Table={'ResultStates'}, CodEERR = {'RNO'},MovType={'Real'}, Account={2601}, SubAccount={'002','008','009','007','012','013','014'}>}January)

Anyway, I would like to know how to do it via E() function.