List box expression

[upaliwije]

Hi Firiends

I have created a expression to limit Ailments to 10 in my list box and other ailments to be shown as OTHERS. How ever it does show only 9 ailments and OTHRES do not apper at all. Pls chcek my below expression and corret my expression.

=aggr(If(Rank(SUM({<CLA_CODE={'SS'},PRL_PTY_CODE={'INP'},ALM_CODE-={"C152","NMT"}>}LBP_CLAIMS_PAID))<=10,ALM_DESC,'OTHERS'),ALM_DESC)   

Thanks

[upaliwije]

Can someone please help me ? If you need further information pls contact me  please

[tresB]

Could you share your sample app?

[upaliwije]

I attach h/w my sample data

[bc-thebruuu]

In the application you provided, the field PRL_PTY_CODE doesn't exists

So ... is smthing like that what you are looking for?

=If(Aggr(Rank(TOTAL SUM({<CLA_CODE={'SS'},ALM_CODE-={"C152","NMT"}>}LBP_CLAIMS_PAID)),ALM_DESC)<=10,ALM_DESC,'OTHERS')

[lanlizgu]

What selections are you doing?

I did a binary to your document using the formula and I see  correctly the list box.

[lanlizgu]

As Bruno mentioned PRL_PTY_CODE doesn't exists but PRL_CODE