Set Analysis using E() function.

Tue, 06 May 2014 15:51:39 GMT

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!

Re: Set Analysis using E() function.

Tue, 06 May 2014 17:58:19 GMT

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.