# Mathematical formulas in collections

**URL:** https://community.glideapps.com/t/mathematical-formulas-in-collections/69557
**Category:** Ask for Help
**Created:** [January 14, 2024, 6:46pm UTC](https://community.glideapps.com/t/mathematical-formulas-in-collections/69557 "2024-01-14T18:46:12Z")
**Posts on this page:** 1
**Showing post:** 6

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [January 14, 2024, 7:40pm UTC](https://community.glideapps.com/t/mathematical-formulas-in-collections/69557/6 "2024-01-14T19:40:04Z")

</div>

OK, that looks like a form, not a collection. Also, you weren’t showing the total balance field in your first screenshot and mentioned that you wanted to calculate the final balance…not the total balance. So, I was a little confused by your question.

First of all, can you confirm that the screen you are showing is a Form or an Edit screen? Are you adding a new row or editing an existing row? Does it have Submit/Cancel buttons at the bottom? If it is a form, you can’t perform calculations in real time because the calculations only occur once the row is added to the table. That only happens when you click on Submit. Also, you will not be able to show a computed value in an entry component, because the entry component is meant for user entry…not for displaying computed values…so you would need a regular text component.

If you want to calculate values in a form in real time, you will need to use a custom form, but it will cost you additional updates.

> [@How do I create a custom form?](https://community.glideapps.com/t/how-do-i-create-a-custom-form/25014):
>
> I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using [User Specific Columns](https://docs.glideapps.com/all/reference/data-editor/user-specific-columns) and [Relations](https://docs.glideapps.com/all/reference/data-editor/computed-columns/relation-column) Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particular…

Screenshots that show the entire screen are a lot more useful that cropped images because there is a lot of sub context that I can obtain from other parts of your screenshot that you may not realize are important.

---

_[View the full topic](https://community.glideapps.com/t/mathematical-formulas-in-collections/69557)._