Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
your Expression Looks good.
what is the outcome? does the result show "-"
is there any data which fits both conditions?
The expression is correct when you combined both of them. What is your expectation of the result ? Can you please share your output.
I figured it out.
Actually the right expression would be:
Sum( {<[Region Lvl 1] = {'NA'} , [Functional P&L] = {'IB Fees'}>} TOTAL(FY16F))
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))