Combining two Set Analysis into 1 equation

[#1]

Hi All,

I'm struggling with this formula. I have 2 set analysis I need to combine

First,

Sum( {<[Region Lvl 1] = {'NA'}>} FY16F)

Second,

Sum( {<[Functional P&L] = { 'IB Fees' }>} FY16F)

So Basically [Region Lvl 1] and [Functional P&L] are columns in my data set.

I thought I can combine two set analysis into 1 by inserting a comma.

Sum( {$<[Region Lvl 1] =    {'NA'} , [Functional P&L] = {'IB Fees'}>} FY16F)

Thanks in Advance for your help!

[Anonymous]

your Expression Looks good.

what is the outcome? does the result show "-"

is there any data which fits both conditions?

[trdandamudi]

The expression is correct when you combined both of them. What is your expectation of the result ? Can you please share your output.

[#4]

I figured it out.

Actually the right expression would be:

Sum( {<[Region Lvl 1] = {'NA'} , [Functional P&L] = {'IB Fees'}>} TOTAL(FY16F))

[sunny_talwar]

Is this an OR condition (Either Region Lvl 1 = NA or Functional P&L = IB Fees?

May be this:

Sum({$<[Region Lvl 1] = {'NA'}> + <[Functional P&L] = {'IB Fees'}>} FY16F)

or just do this:

RangeSum(Sum({<[Region Lvl 1] = {'NA'}>} FY16F), Sum( {<[Functional P&L] = { 'IB Fees' }>} FY16F))