Skip to main content

Calculate Remaining Balance


1 comment

  • Tiffanie Staver
    Witte commented  ·  


    There are multiple ways to approach this, and some of your options may be more effective than others based on your current workflow and table design. I will do my best to describe a few options here, but please feel free to contact our Support Team directly at 800-673-3302 or if you would like further assistance.

    One option would be to create a new field called Partial Payment, the edit the formula in your Balance field to also subtract this new field (Total Cost - (Deposit + Partial Payment)). If a Partial Payment is made, you input the number into your Partial Payment field and the Balance will update automatically. If they do not make a partial payment, you can leave this field blank and the Balance calculation will be unaffected.

    if you are attempting to track these partial payments, you could instead a new child table called Partial Payments. These partial payment records could then be added together on the parent table using a sum function, and this total could then by subtracted from the Total Cost in the same manner as the example above.

    I hope this is helpful. Please don't hesitate to reach out if you have any additional questions,



Please sign in to leave a comment.

Powered by Zendesk