Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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