Self Join portal summary
I have a database of users with balances due on their account. I have created a calculation CallList_c to equal "Call List" if their balance is >0 as follows:
Dues Outstanding is a sumamry field (I think herein lies my problem):
If(DuesBilled_s - DuesPaid_s=0;0;DuesBilled_s - DuesPaid_s)
Since all of these are summary flelds and cannot be indexed, I believe this is the reason the portal comes up empty.
Can someone suggest a better approach. I just need to list all members in a portal that have balances greater than zero.