# Roll up Lookups With Negative number

**URL:** https://community.glideapps.com/t/roll-up-lookups-with-negative-number/17203
**Category:** Ask for Help
**Created:** [October 16, 2020, 4:41am UTC](https://community.glideapps.com/t/roll-up-lookups-with-negative-number/17203 "2020-10-16T04:41:29Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![akmis](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/akmis/32/15301_2.png) [@akmis](https://community.glideapps.com/u/akmis)
#### Post date: [October 16, 2020, 4:41am UTC](https://community.glideapps.com/t/roll-up-lookups-with-negative-number/17203/1 "2020-10-16T04:41:29Z")

</div>

Hi.

I have a column of lookup to return relation of a tables containing number, (Hopefully 1 positive and 1 negative to indicated the status of the item.

i tried to rollup the relation, however sum is not available.

i then tried to rollup the lookup field, it is not selectable in the drop down.

Below f  
 ![lookup](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/4f9a88b687b98e4facb93e47293d0d573aa5bd9a.png)

---

<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: [October 16, 2020, 5:15am UTC](https://community.glideapps.com/t/roll-up-lookups-with-negative-number/17203/2 "2020-10-16T05:15:49Z")

</div>

You can try using a math column, point to your If Then Else and multiply by one, then try rolling that up instead of the original one.