Include Isnull in setanalysis

[bharatkishore]

Hi All,

I have the following expression.

=Sum({<days={">=5  <10"}>}[LC2 Amount])

I want to add isnull into this expression.

I have tried this expression:

=Sum({<days={">=5  <10"}>}if(isnull([Clrng doc]),[LC2 Amount]))

But there value is not matching. If i click on the filter then the value is matching.

Is there anything wrong in my expression.

Thanks,

R. Bharat Kishore

[bharatkishore · Accepted solution]

Sorry i have got this..

[Chanty4u]

try single quotes

=Sum({<days={'>=5  <10'}>}if(isnull([Clrng doc]),[LC2 Amount]))

• how to write a Sum Set analysis isNull condition