Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You may use
Sum({$<Qtr = {1,2}>} Amt) - Sum({$<Qtr = {3}>} Amt)
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
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
Hi,
Try like this
Sum({$<Qtr = {1,2}-{3}>} Amt)
Thanks & Regards
Harsha Nandan
It's only sum up of 1 & 2, 3 does not subtract
I am looking like this solution
Thanks