How do I perform a find on a field that has a summary total?
I have a portal that records payments and payment dates for each client. When I total the payments (either Sum or Summary) I cant index the field due to restrictions. That prevents me from performing a find (all clients with balances >0). Seems so easy yet I have spent hours trying different scenarios. I am always stuck with a related field that prevents indexing. Any suggestion? thanks!