Value filters in List Box

[anuradhaa]

Hi,

I have created a list box and i need to filter values in it.

My list box is patrons and i have included the expression  "=Money (sum( BILL_AMT) )"

in my list box.

Here Patron is one table and BILL_AMT in another table

But i need to show the patrons that have "=Money (sum( BILL_AMT) )>0" values.

So Pls help me to solw this problem.

Thanks

[#2]

Hi anu,

try within the listbox an expression similar to this:

=if(aggr(sum(BILL_AMT), Patron) >0, Patron)

Regards

Roland

[anuradhaa]

Hi,

Thanks, This works for me. but still have a problem.

Now it will not show the sum( BILL_AMT) =0 value in the list box. But it display the text of the Patron name in the list box without that value. please help me to remove that text values also.

Thanks

[#4 · Accepted solution]

Hi again,

take a look at attached example, expression of second listbox --> Is this what you want ?

HtH

Roland

[anuradhaa]

Hi Roland,

Yes the aggr function solve my issue.

Thanks