Set Analysis - Empty subset

[#1]

Hi,

I am doing some basic set analyis things but I am not able to find a solution for this problem. I am just calculating a sum over a subset of the current selection:

Sum({$<Check={'Y'}>} SumField)

Basically this works fine, but when there is no value Check='Y' in the current selection, the expression calcualtes the sum of all values in SumField. How can I change this expression so it returns zero in that case?

Thanks for your help

[petter]

Maybe:

RangeSum(Sum({$<Check={'Y'}>} SumField),0)

[#3]

Hi,

Try this:

=NumSum(Sum({$<Check={'Y'}>} SumField),0)

[tresesco]

May be like:

              Sum({$<Check * = {'Y'}>} SumField)

[#5]

Try this...

if( Check = 'Y', Sum({$<Check={'Y'}>} SumField), 0)