# Can't rollup with 'sum' for a math column?

**URL:** <https://community.glideapps.com/t/cant-rollup-with-sum-for-a-math-column/63696>\
**Category:** Ask for Help\
**Created:** [July 9, 2023, 9:44pm UTC](https://community.glideapps.com/t/cant-rollup-with-sum-for-a-math-column/63696 "2023-07-09T21:44:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jwilt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jwilt/32/37710_2.png) [@jwilt](https://community.glideapps.com/u/jwilt)\
**Post date:** [July 9, 2023, 9:44pm UTC](https://community.glideapps.com/t/cant-rollup-with-sum-for-a-math-column/63696/1 "2023-07-09T21:44:52Z")

</div>

I’m trying to add up numbers from a math column by creating another rollup column and choosing ‘sum’ but it doesn’t show that as an option. It seems you only get sum when it’s a number column? You would think a math column would allow you to sum what’s in it?

 ![Screenshot 2023-07-09 at 5.44.00 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/4/2415b72fccf2049f36ee4b9c9e0899cb701cc891.png)

---

<div class="post-metadata">

**Author:** ![jwilt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jwilt/32/37710_2.png) [@jwilt](https://community.glideapps.com/u/jwilt)\
**Post date:** [July 9, 2023, 9:49pm UTC](https://community.glideapps.com/t/cant-rollup-with-sum-for-a-math-column/63696/2 "2023-07-09T21:49:45Z")

</div>

For anyone else who struggles with this, I figured out a workaround. The math column has to have an equation of some kind in it. In my case, I had it just converting another column that was an OpenAI response of a number into a $ number. It wouldn’t let me do a rollup just based on that. But I messed with it by just multiplying by 1 and then it worked. Now I can do a rollup and ‘sum’ on this value.

 ![Screenshot 2023-07-09 at 5.49.28 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/0/2055aa11a97bc2cdbaa27dc0c6c213948f8dc343.png)

---

<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:** [July 10, 2023, 9:50pm UTC](https://community.glideapps.com/t/cant-rollup-with-sum-for-a-math-column/63696/3 "2023-07-10T21:50:06Z")

</div>

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