# Math wanted to calculate with relation

**URL:** <https://community.glideapps.com/t/math-wanted-to-calculate-with-relation/75343>\
**Category:** Ask for Help\
**Created:** [August 1, 2024, 8:58am UTC](https://community.glideapps.com/t/math-wanted-to-calculate-with-relation/75343 "2024-08-01T08:58:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Quinjoes](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/quinjoes/32/78166_2.png) [@Quinjoes](https://community.glideapps.com/u/Quinjoes)\
**Post date:** [August 1, 2024, 8:58am UTC](https://community.glideapps.com/t/math-wanted-to-calculate-with-relation/75343/1 "2024-08-01T08:58:14Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/c/0cea7101a7f69af18ba28ab8292102a31d46111f.png)  
I wanted the productSquareMeters \* Services and from services the price? How can i achieve that?

---

<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:** [August 1, 2024, 12:13pm UTC](https://community.glideapps.com/t/math-wanted-to-calculate-with-relation/75343/2 "2024-08-01T12:13:46Z")

</div>

Create a single relation linking the Service column in the Quotes table to the Service column in the Services table. Then create a Lookup column that retrieves the price from that relation.

You may also want to change the column type to numeric for any columns that are going to contain numbers and be used for math.

---

<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:** [August 8, 2024, 12:14pm UTC](https://community.glideapps.com/t/math-wanted-to-calculate-with-relation/75343/3 "2024-08-08T12:14:37Z")

</div>

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