AnsweredAssumed Answered

Help Calc field displays as "0" on layout

Question asked by user13898 on Nov 5, 2016
Latest reply on Nov 5, 2016 by keywords

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?

Outcomes