# Need Help: In math column can't we get lookup values if they are numbers?

**URL:** <https://community.glideapps.com/t/need-help-in-math-column-cant-we-get-lookup-values-if-they-are-numbers/78616>\
**Category:** Ask for Help\
**Created:** [December 15, 2024, 12:58pm UTC](https://community.glideapps.com/t/need-help-in-math-column-cant-we-get-lookup-values-if-they-are-numbers/78616 "2024-12-15T12:58:42Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [December 15, 2024, 12:58pm UTC](https://community.glideapps.com/t/need-help-in-math-column-cant-we-get-lookup-values-if-they-are-numbers/78616/1 "2024-12-15T12:58:42Z")

</div>

Hi Guys,

I have a math column where I need to calculate total Amount after applying discounts.

I am getting the discount value based on brand selected from a different table by using a lookup column. But In math column I am not able to get this numerical Lookup value.

Can someone please guide me what can I do to get solution for this?

Thank you in advance for your help

Regards,  
Dilip

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 15, 2024, 2:02pm UTC](https://community.glideapps.com/t/need-help-in-math-column-cant-we-get-lookup-values-if-they-are-numbers/78616/2 "2024-12-15T14:02:23Z")

</div>

Is the lookup via a relation?  
If yes, make sure it is a single relation.

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [December 15, 2024, 2:10pm UTC](https://community.glideapps.com/t/need-help-in-math-column-cant-we-get-lookup-values-if-they-are-numbers/78616/3 "2024-12-15T14:10:10Z")

</div>

Hi @Darren_Murphy ,

The lookup value is via Query column.

Is there any way I can get this lookup value into Math column?

Or what would be the workaround?

My Problem:

I have brands running multiple campaigns under them. Which is stored in campaigns table Which has % discount value.

When user is checking out in the checkout page, when he enters the amount, it has to check the brand\_idfrom campaigns table, check which campaign is active and enter the correct %discount and then calculate the total amount to be paid for this I need the math column.

The checkout happens in seperate table called BillChckout.

I need query column as I need to check which campaign is active and apply the correct %discount. But I believe query column lookup output does not let you put value to math column?

Can you guide me as to what solution can I apply for this?

Thank you in advance for your help.

Regards,  
Dilip

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 15, 2024, 2:22pm UTC](https://community.glideapps.com/t/need-help-in-math-column-cant-we-get-lookup-values-if-they-are-numbers/78616/4 "2024-12-15T14:22:01Z")

</div>

Use a single value column to take the first value from the query.

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [December 15, 2024, 2:36pm UTC](https://community.glideapps.com/t/need-help-in-math-column-cant-we-get-lookup-values-if-they-are-numbers/78616/5 "2024-12-15T14:36:21Z")

</div>

Hi @Darren_Murphy ,

Thank you for suggesting this and helping me out.

It works very well 🙂

Regards,  
Dilip

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [December 22, 2024, 2:37pm UTC](https://community.glideapps.com/t/need-help-in-math-column-cant-we-get-lookup-values-if-they-are-numbers/78616/6 "2024-12-22T14:37:13Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.