worked all night on this, changed all the conditional formatting, deleted quick find etc
searched for answers but might not be using the correct question
I have a field "balance owed" from the current table on the layout.
I have another field "payments made" from a related field which summarizes all the payments made on the account.
Both of these display correctly.
I created a third field which is the "balance remaining" by Sum ( balance_owed) - ( table2::payments_made)
the "balance remaining" field displays as 0 in browse mode but the value displays correctly with the dataviewer tool
This has got to be simple... right?