Balance Not Updating Correctly When Multiple Programs Are Approved

Ask the Community Get Answers
1

Hi all,

I’m building a website using Knack where users can apply for different programs. On the user details page, I display their Total Coverage and Balance After Programs.

The issue I’m facing is that when a user has been approved for multiple programs, the Balance After Programs doesn’t update correctly. For example, if two programs both cost $500, I expect the balance to reduce by $1000. But instead, it only reduces by $500, and shows $1000 twice (screenshot below):

Screenshot 2025-05-27 123138
Screenshot 2025-05-27 1231381158×534 34.1 KB

See how both of those cost 500 and it just displays 1000 two times this is the equation I’m using for Balance after program {Application Users.Coverage amount} - {Application Program.Maximum Coverage} any help would be appreciated

Thanks John,

2

Shouldn’t you be deducting a sum of the application programs costs and not a max value?

3

In Applications Users, set up a formula field called Spent (or whatever) which is a SUM of the connected program costs in the Application program table (I assume the cost is in that table). This should equal $1000.

Then display another equation field BALANCE which is {Application Users.Coverage amount} - {Application Users.Spent} = $500.