I am trying to create a custom view for each location to show how much money each user still owes in fees/fines.

We apply fees for damaged devices to user profiles. The users are also assigned locations.

I created a view with a filter for a specific location, a balance greater than 0, and specific grade levels. I then the columns are Asset Tag, Serial Number, Owner, and Balance.

It is showing me the total amount of fees per user but not what the current / remaining balance is. 

For example, a user owes $50 but has paid $30. The view shows the user with a balance of $50.

I’m not sure if I am missing a setting or filter or if there is some way to add a new “Outstanding Balance” filter. Please Advise 

EDIT* This is using the Fee Tracker App Publisher by Incident IQ Team