Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello:
I'm trying to write a Sum expression where I sum based if A like B AND Y like Z.
1st you don't have the set analysis correctly for CIO (incorrect placement of curly bracket)
=Num(Sum({$<[Phase] = {'Finance*'}, {CIO = {'*'}>} RangeMax([Estimated Saves Minus Implementation Cost], 0)/1000000),'$###0') + Num(Sum({$<[Phase] = {Booked}>} RangeMax([Finance Confirmed 2016 Savings], 0)/1000000),'$###0')
So you are looking to avoid selection in CIO regardless of selection in CIO? May be this:
=Num(Sum({$<[Phase] = {'Finance*'}, CIO>} RangeMax([Estimated Saves Minus Implementation Cost], 0)/1000000),'$###0') + Num(Sum({$<[Phase] = {Booked}, CIO>} RangeMax([Finance Confirmed 2016 Savings], 0)/1000000),'$###0')
1st you don't have the set analysis correctly for CIO (incorrect placement of curly bracket)
=Num(Sum({$<[Phase] = {'Finance*'}, {CIO = {'*'}>} RangeMax([Estimated Saves Minus Implementation Cost], 0)/1000000),'$###0') + Num(Sum({$<[Phase] = {Booked}>} RangeMax([Finance Confirmed 2016 Savings], 0)/1000000),'$###0')
So you are looking to avoid selection in CIO regardless of selection in CIO? May be this:
=Num(Sum({$<[Phase] = {'Finance*'}, CIO>} RangeMax([Estimated Saves Minus Implementation Cost], 0)/1000000),'$###0') + Num(Sum({$<[Phase] = {Booked}, CIO>} RangeMax([Finance Confirmed 2016 Savings], 0)/1000000),'$###0')
Bit syntax error in your orginal expression:
=Num(Sum({$<[Phase] = {'Finance*'}, CIO = {'*'}>} RangeMax([Estimated Saves Minus Implementation Cost], 0)/1000000),'$###0') + Num(Sum({$<[Phase] = {Booked}>} RangeMax([Finance Confirmed 2016 Savings], 0)/1000000),'$###0')
Hello Sunny:
My apologies for the delay in replying. Year End and it's crazy, Anyway, yes, this works and very simple. I continue to learn from one of the best! Thank you, as always.
Srikanth:
As with Sunny, my apologies for the delay in replying. This was helpful and thanks for catching the syntax error.