AnsweredAssumed Answered

Self Join portal summary

Question asked by glucas on Nov 9, 2009
Latest reply on Nov 9, 2009 by philmodjunk


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: 


 If(DuesOutstanding_s>1;"Call List";"")


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.