How to write this Set analysis

[#1]

Hi Experts,

I have two tables:

tb1:

MemberId, Flag2

1,1

2, null value

tb2:

MemberId,Flag, Usage

1,1,100

2,2,200

It is clear that the MemberId is used as connection Key.

Now I want to use Set analysis to get the usage whose Flag2 is Null.

I use this one =sum({<Flag2={'=IsNull(Flag2)'}>} Usage), but it does not work, how to write it? And I want it show in Text Object.

Thanks.

[sbaldwin · Accepted solution]

Hi, You could try something like this:

=count( {<MemberId = e({<Flag2 = {'>0'} >} MemberId)  >} MemberId)

in a table against usage or in a text box if there is only one:

=only( {<MemberId = e({<Flag2 = {'>0'} >} MemberId)  >} Usage)

Thanks

Steve