Single Set Analysis

[Anonymous]

Hi All

Below Set Analysis possible as single?

Sum({$<Qtr = {1,2}> Amt) - Sum({Qtr = {3} Amt)

Question is instead of summing (Qtr = {1,2}) and subtracting (Qtr = {3}) is that possible the above SA in single Set Analysis ?

Thanks

[nagaiank]

You may use

Sum({$<Qtr = {1,2}>} Amt) - Sum({$<Qtr = {3}>} Amt)

[Anonymous]

Hi NagaianK

I agree and I have used the same, I also agree my question is little confusing.

I am trying to figure out if possible in single Set Ana like

Sum({$<Qtr = {1,2}>} Amt)

and Qtr = 3 within above only rather than Sum({$<Qtr = {1,2}>} Amt)  - Sum({$<Qtr = {3}>} Amt)

Thanks for your sugestion

[#4]

Hi Satish,

you can use different operators within set analysis, have a look at this for more on those

Set Analysis: syntaxes, examples

but you won't be able to do what you are looking for in this scenario from a single set I'm afraid no.

Joe

[#5]

Hi,

Try like this

Sum({$<Qtr = {1,2}-{3}>} Amt)

Thanks & Regards

Harsha Nandan

[Anonymous]

It's only sum up of 1 & 2, 3 does not subtract

I am looking like this solution

Thanks