1 2 Previous Next 19 Replies Latest reply on Nov 5, 2016 4:55 PM by keywords

    Help Calc field displays as "0" on layout


      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?

        1 2 Previous Next