# Calculation on connection - dropdown field

**URL:** <https://forums.knack.com/t/calculation-on-connection-dropdown-field/11501>\
**Category:** Get Answers\
**Created:** [November 7, 2021, 12:33pm UTC](https://forums.knack.com/t/calculation-on-connection-dropdown-field/11501 "2021-11-07T12:33:28Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![RONALD](https://avatars.discourse-cdn.com/v4/letter/r/ea666f/32.png) [@RONALD](https://forums.knack.com/u/RONALD)\
**Post date:** [November 7, 2021, 12:33pm UTC](https://forums.knack.com/t/calculation-on-connection-dropdown-field/11501/1 "2021-11-07T12:33:28Z")

</div>

Hi everyone, so I have a value on the dropdown that wanted to include in the equation but doesn’t show on the field list. What is the workaround for this? Thanks 🙂

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/3/35846ae454bb06b6a2f59b234dd77ee085141448.png)

Here’s my equation field.  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/9/9903d3095273f89da710e2c5e69bce3ec949d205.png)

---

<div class="post-metadata">

**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\
**Post date:** [November 7, 2021, 10:25pm UTC](https://forums.knack.com/t/calculation-on-connection-dropdown-field/11501/2 "2021-11-07T22:25:38Z")

</div>

Type the field name into the equation field dialogue box (where you have {quantity}.  
Start trying with an open curly bracket “{“ and you will be presented with an extended list of options from all related tables.

---

<div class="post-metadata">

**Author:** ![RONALD](https://avatars.discourse-cdn.com/v4/letter/r/ea666f/32.png) [@RONALD](https://forums.knack.com/u/RONALD)\
**Post date:** [November 7, 2021, 11:21pm UTC](https://forums.knack.com/t/calculation-on-connection-dropdown-field/11501/3 "2021-11-07T23:21:51Z")

</div>

@CarlHolmes doesn’t show the calculation on the form but when I hit the submit button, the calculation displays on the table.

Here’s the form

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/9/94aaf269dd07e342294a7b3946a4edfe433dd438.png)

Here’s the table

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/2/29dbbf1ade1d29cc3d76537d67e6f23ec644238e.png)

Here’s my equation on the form

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/d/dbe55b73df798db2182d8bc8d66c0ca9486bbd74.png)

---

<div class="post-metadata">

**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\
**Post date:** [November 8, 2021, 8:48am UTC](https://forums.knack.com/t/calculation-on-connection-dropdown-field/11501/4 "2021-11-08T08:48:25Z")

</div>

It relates to you using the values from a connected field in your drop down field. I presume you have a related table (MinFee) which is populating the drop down. If this is the case then the equation total won’t update until the record is written. Is there a need to know the total when adding the record?

If you just used a numeric value field in the same table the total will calculate on the fly but this is not the case with a related table forming part of the calculation. I’d simply remove the total and just let the user add the data and show the result in your details view post record being added.

---

<div class="post-metadata">

**Author:** ![RONALD](https://avatars.discourse-cdn.com/v4/letter/r/ea666f/32.png) [@RONALD](https://forums.knack.com/u/RONALD)\
**Post date:** [November 10, 2021, 11:00am UTC](https://forums.knack.com/t/calculation-on-connection-dropdown-field/11501/5 "2021-11-10T11:00:04Z")

</div>

@CarlHolmes Yes correct, there is a related table (MinFee) that is populating the dropdown. As you can see in the below snapshot, the dropdown value doesn’t calculate automatically on the form BUT when I hit the submit button, the calculation is showing on the table.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/6/6a47c7cda23b7fea882335dcd8f2c2c4fcf6e87e.png)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/5/591cfcabb570c4f4190273ad17d598cae1a75757.png)

---

<div class="post-metadata">

**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\
**Post date:** [November 10, 2021, 12:22pm UTC](https://forums.knack.com/t/calculation-on-connection-dropdown-field/11501/6 "2021-11-10T12:22:41Z")

</div>

I refer you to my original reply 😊  
It won’t calculate on the form when using a value from a connected object.  
I’d remove the equation total fields and show in a details view after they have added the record.

---

<div class="post-metadata">

**Author:** ![RONALD](https://avatars.discourse-cdn.com/v4/letter/r/ea666f/32.png) [@RONALD](https://forums.knack.com/u/RONALD)\
**Post date:** [November 10, 2021, 11:07pm UTC](https://forums.knack.com/t/calculation-on-connection-dropdown-field/11501/7 "2021-11-10T23:07:22Z")

</div>

Thanks, @CarlHolmes. Got your point 🙂 . I guess you can’t do it unless you’ll make a custom script out of it? Appreciate your suggestion.
