# Math Issue Question

**URL:** <https://community.glideapps.com/t/math-issue-question/57665>\
**Category:** Ask for Help\
**Created:** [February 8, 2023, 4:09pm UTC](https://community.glideapps.com/t/math-issue-question/57665 "2023-02-08T16:09:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![larry](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/larry/32/1643_2.png) [@larry](https://community.glideapps.com/u/larry)\
**Post date:** [February 8, 2023, 4:09pm UTC](https://community.glideapps.com/t/math-issue-question/57665/1 "2023-02-08T16:09:37Z")

</div>

I’m trying to add two columns (Food Price + QTY) to get a total. When I use the math function it doesn’t recognize the Food Price column which is a lookup column. Any suggestions please send them my way.

![ccc](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/1/313461747c178785f96404dd91e95bb028c7f002.jpeg)

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [February 8, 2023, 4:25pm UTC](https://community.glideapps.com/t/math-issue-question/57665/3 "2023-02-08T16:25:04Z")

</div>

You are using the lookup column through a relation, and this relation seems to be a multiple relation. Any chance you can make this relation a single relation? This way the lookup column would return a single value rather than an array (with a single element).

Also, could you make sure the initial price column is a basic number column? This seems to be the case but it doesn’t hurt to double-check.

Not my business, but are you sure you want to _add_ price and quantity? A more natural use case would be to _multiply_ price and quantity, and in that case you would use an asterisk \* as the multiplication operator in the math column.

---

<div class="post-metadata">

**Author:** ![larry](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/larry/32/1643_2.png) [@larry](https://community.glideapps.com/u/larry)\
**Post date:** [February 8, 2023, 10:15pm UTC](https://community.glideapps.com/t/math-issue-question/57665/4 "2023-02-08T22:15:17Z")

</div>

Thank you so much for your feedback. Yes, I’m multiplying not adding, that was an error on my part. lol

---

<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:** [February 9, 2023, 10:15pm UTC](https://community.glideapps.com/t/math-issue-question/57665/5 "2023-02-09T22:15:30Z")

</div>

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