# Math column doesn't add a lookup column

**URL:** <https://community.glideapps.com/t/math-column-doesnt-add-a-lookup-column/22887>\
**Category:** Report a Bug\
**Created:** [February 16, 2021, 5:53pm UTC](https://community.glideapps.com/t/math-column-doesnt-add-a-lookup-column/22887 "2021-02-16T17:53:05Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\
**Post date:** [February 16, 2021, 5:53pm UTC](https://community.glideapps.com/t/math-column-doesnt-add-a-lookup-column/22887/1 "2021-02-16T17:53:05Z")

</div>

My app’s URL: [https://nervous-tank-8406.glideapp.io/](https://nervous-tank-8406.glideapp.io/)  
I’ve tried to implement a math formula which adds the current value plus the previous total through a relation, but there seems to be a bug and the math column doesn’t add the previous value.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/d/5d63923d54d4c0449da856f5b84859d9c492c62b.png)  
(I’ve reported this in [this post](https://community.glideapps.com/t/math-formula/22807/4), but its thread isn’t categorized as Bugs)

---

<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:** [February 16, 2021, 5:59pm UTC](https://community.glideapps.com/t/math-column-doesnt-add-a-lookup-column/22887/2 "2021-02-16T17:59:37Z")

</div>

Could be the fact that it’s a lookup column. You might have to convert it to a numeric column by adding a Math column just to convert the one column. Then point your original math column to that new math column.

---

<div class="post-metadata">

**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\
**Post date:** [February 16, 2021, 6:02pm UTC](https://community.glideapps.com/t/math-column-doesnt-add-a-lookup-column/22887/3 "2021-02-16T18:02:07Z")

</div>

Thanks. I’ve already tried that with the same result

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 16, 2021, 11:27pm UTC](https://community.glideapps.com/t/math-column-doesnt-add-a-lookup-column/22887/4 "2021-02-16T23:27:53Z")

</div>

What’s the original column type of the “sum ant”?

---

<div class="post-metadata">

**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\
**Post date:** [February 17, 2021, 8:14pm UTC](https://community.glideapps.com/t/math-column-doesnt-add-a-lookup-column/22887/5 "2021-02-17T20:14:24Z")

</div>

It’s the math column itself with the previous item value.  
I’m trying to do something like E7 = D7 + E6 or sum = value + sum

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [February 17, 2021, 8:23pm UTC](https://community.glideapps.com/t/math-column-doesnt-add-a-lookup-column/22887/6 "2021-02-17T20:23:59Z")

</div>

Hola!

Is your relation simple or multiple?

This must be simple!

---

<div class="post-metadata">

**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\
**Post date:** [February 17, 2021, 8:43pm UTC](https://community.glideapps.com/t/math-column-doesnt-add-a-lookup-column/22887/7 "2021-02-17T20:43:28Z")

</div>

It’s simple

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [February 17, 2021, 9:49pm UTC](https://community.glideapps.com/t/math-column-doesnt-add-a-lookup-column/22887/8 "2021-02-17T21:49:53Z")

</div>

I see…

Just a fast test, write this as formula and tell us what you get:

`item + ant*1`

Saludos

---

<div class="post-metadata">

**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\
**Post date:** [February 18, 2021, 1:28pm UTC](https://community.glideapps.com/t/math-column-doesnt-add-a-lookup-column/22887/9 "2021-02-18T13:28:31Z")

</div>

It works!  
Thanks
