Set analysis

[mario-sarkis]

hey All

my question is  i have this fields

Currency       amount

001                1000

002                1500

003                1500

004                2000

005                1000

006                 500

i need to do the summation of amount with condition the currency has to be diffrent then 001 and 002

Sum({<Currency <>{'001','002'}>}Amount) this isn't work

Thank you hope you can help

[#2]

Hi ,

try this

Sum({<Currency -={'001','002'}>}Amount)

[prashantbaste]

Hi Mario

You can try sum( {$<Currency= E({1<Currency={'001','002'}>})>} Amount)

Let me know if this is helpful for you?

--

Regards,

Prashant P Baste

[Anonymous]

Hi,

You can even use um({<Currency={'*'}-{'001','002'}>}Amount)

[krishna20]

Hi,

Try like

Sum({<Currency<>{'001'}>}Amount) + Sum({<Currency<>{'002'}>}Amount)

[Anonymous]

Hi,

Follow the procedure:

1. First select expression as sum(amount) and create a pie chart.

2. Select 001 and 002 currency and add a bookmark with name 'book'.

3. Now, go to properties and change expression with following expression:

          =sum({1-Book}(amount))

That's it.

You will get a pie chart which will be showing currency except 001 and 002.

Have a look over following example.

[vcanale]

Hi,
try this:

sum({$<Currency={'*'}-{'001','002'}>}Amount)

[sasiparupudi1 · Accepted solution]

sum(amount)-sum({<Currency={'001','002'}>}amount)

[Anonymous]

Hi,

Follow the procedure:

1. First select expression as sum(amount) and create a pie chart.

2. Select 001 and 002 currency and add a bookmark with name 'book'.

3. Now, go to properties and change expression with following expression:

          =sum({1-Book}(amount))

That's it.

You will get a pie chart which will be showing currency except 001 and 002.

[Gabriel]

Hi,

Try using this Set Analysis. What you wanted to say in your expression is give me the sum of Amount , Where currency ={*} all currency but remove Where currency = 001,002 that's where you use - {001,002}

Here is the solutions

({$<Currency = {*} - {001,002}>} amount)

Let me know if it work