# Using a Look Up value to do math

**URL:** <https://community.glideapps.com/t/using-a-look-up-value-to-do-math/43423>\
**Category:** Ask for Help\
**Created:** [June 23, 2022, 9:51pm UTC](https://community.glideapps.com/t/using-a-look-up-value-to-do-math/43423 "2022-06-23T21:51:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sparkler](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@Sparkler](https://community.glideapps.com/u/Sparkler)\
**Post date:** [June 23, 2022, 9:51pm UTC](https://community.glideapps.com/t/using-a-look-up-value-to-do-math/43423/1 "2022-06-23T21:51:45Z")

</div>

I am trying to create an invoicing system that is all interconnected, the template out there is really not adequate.

So my question:

I created a relation for a Service, then I create a look up to get the rate. So now I wanted to take the rate and multiply it by time to get an invoice amount. But I don’t have the option to do that because you can’t multiply or do any math operation on a look up value.

Any suggestions?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [June 23, 2022, 10:19pm UTC](https://community.glideapps.com/t/using-a-look-up-value-to-do-math/43423/2 "2022-06-23T22:19:53Z")

</div>

You should be able to. Make sure the original column you’re bringing in is formatted as a number column.

---

<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:** [June 23, 2022, 10:33pm UTC](https://community.glideapps.com/t/using-a-look-up-value-to-do-math/43423/3 "2022-06-23T22:33:24Z")

</div>

Also make sure the lookup isn’t coming from a multiple relation. It should be a single relation.

---

<div class="post-metadata">

**Author:** ![Sparkler](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@Sparkler](https://community.glideapps.com/u/Sparkler)\
**Post date:** [June 24, 2022, 10:48pm UTC](https://community.glideapps.com/t/using-a-look-up-value-to-do-math/43423/4 "2022-06-24T22:48:30Z")

</div>

Thanks, I was able to figure it out with your help

---

<div class="post-metadata">

**Author:** ![drascon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drascon/32/20070_2.png) [@drascon](https://community.glideapps.com/u/drascon)\
**Post date:** [September 28, 2022, 11:47pm UTC](https://community.glideapps.com/t/using-a-look-up-value-to-do-math/43423/5 "2022-09-28T23:47:09Z")

</div>

Just solved one of the issues I’ve been trying to fix for the last few hours, thanks to @Robert_Petitto and @Jeff_Hager - thanks dudes! Also, the lookup column can pull from a math column for this to work too 👍