AnsweredAssumed Answered

Self Join portal summary

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

Title

Self Join portal summary

Post

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. 

Outcomes