Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can someone please help me ? If you need further information pls contact me please
Could you share your sample app?
I attach h/w my sample data
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')
What selections are you doing?
I did a binary to your document using the formula and I see correctly the list box.
As Bruno mentioned PRL_PTY_CODE doesn't exists but PRL_CODE