# Rollup math functions are not working with if-else column

**URL:** <https://community.glideapps.com/t/rollup-math-functions-are-not-working-with-if-else-column/14121>\
**Category:** Report a Bug\
**Created:** [August 18, 2020, 2:21am UTC](https://community.glideapps.com/t/rollup-math-functions-are-not-working-with-if-else-column/14121 "2020-08-18T02:21:21Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![zeki](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zeki/32/9068_2.png) [@zeki](https://community.glideapps.com/u/zeki)\
**Post date:** [August 18, 2020, 2:21am UTC](https://community.glideapps.com/t/rollup-math-functions-are-not-working-with-if-else-column/14121/1 "2020-08-18T02:21:21Z")

</div>

Rollups SUM, AVERAGE, MIN, MAX, RANGE functions are not working with if-else column which are referenced from number columns

---

<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:** [August 18, 2020, 2:31am UTC](https://community.glideapps.com/t/rollup-math-functions-are-not-working-with-if-else-column/14121/2 "2020-08-18T02:31:51Z")

</div>

Probably they are seen as text. Would it work if you create a math column and reference that ITE?

---

<div class="post-metadata">

**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\
**Post date:** [August 18, 2020, 9:09am UTC](https://community.glideapps.com/t/rollup-math-functions-are-not-working-with-if-else-column/14121/3 "2020-08-18T09:09:02Z")

</div>

Check the data type of the IF ELSE column.

---

<div class="post-metadata">

**Author:** ![zeki](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zeki/32/9068_2.png) [@zeki](https://community.glideapps.com/u/zeki)\
**Post date:** [August 18, 2020, 10:28am UTC](https://community.glideapps.com/t/rollup-math-functions-are-not-working-with-if-else-column/14121/4 "2020-08-18T10:28:00Z")

</div>

There is no data type choice in if-else  
But checked all the parameters and the are all in number format

---

<div class="post-metadata">

**Author:** ![zeki](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zeki/32/9068_2.png) [@zeki](https://community.glideapps.com/u/zeki)\
**Post date:** [August 18, 2020, 10:29am UTC](https://community.glideapps.com/t/rollup-math-functions-are-not-working-with-if-else-column/14121/5 "2020-08-18T10:29:04Z")

</div>

Currently, I’m using a math column and multiplying it with 1 in order to convert it.  
But the column is in currency format and normally glide can calculate the currency format before if-else valuation.

---

<div class="post-metadata">

**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\
**Post date:** [August 18, 2020, 12:27pm UTC](https://community.glideapps.com/t/rollup-math-functions-are-not-working-with-if-else-column/14121/6 "2020-08-18T12:27:36Z")

</div>

Yeah, my bad. I meant to suggest that you check all the outputs are in the same format.

---

<div class="post-metadata">

**Author:** ![zeki](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zeki/32/9068_2.png) [@zeki](https://community.glideapps.com/u/zeki)\
**Post date:** [August 18, 2020, 2:21pm UTC](https://community.glideapps.com/t/rollup-math-functions-are-not-working-with-if-else-column/14121/7 "2020-08-18T14:21:38Z")

</div>

Hello @sardamit  
I did it as well.  
The only workaround for me was converting it with math formula for now.  
I will add currency with template column.  
I wish, we could have a chance to use variable in “unit” field inside math column.