# SUM via rollup tips

**URL:** <https://community.glideapps.com/t/sum-via-rollup-tips/55678>\
**Category:** Report a Bug\
**Created:** [December 12, 2022, 3:29pm UTC](https://community.glideapps.com/t/sum-via-rollup-tips/55678 "2022-12-12T15:29:38Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Martin\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martin_b/32/74360_2.png) [@Martin\_B](https://community.glideapps.com/u/Martin_B)\
**Post date:** [December 12, 2022, 3:29pm UTC](https://community.glideapps.com/t/sum-via-rollup-tips/55678/1 "2022-12-12T15:29:38Z")

</div>

Hello,

Just to let you know this essential tip:

if you want to do SUM (roll up column) you need to target number format value.

Not IFthenELSE with other IF then else in it or template etc …

So the trick is:  
1/create SUM column first by targeting a temporary number column.  
set SUM.

2/ create the columns you need, IfthenElse etc…

3/Change the target inside the SUM (rollupcolumn) to your desired column.  
But dont touch the dropdown of computing or the name of the column or anything.

Then the rollup column will stay in SUM mode… even if your target is a IF column with sometimes TEXT, or FALSE or empty…

Have a nice day

---

<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:** [December 13, 2022, 12:10am UTC](https://community.glideapps.com/t/sum-via-rollup-tips/55678/2 "2022-12-13T00:10:33Z")

</div>

So are you trying to share the tip or reporting this as a bug? If you don’t want to report this as a bug, we can help changing the category to be appropriate.

---

<div class="post-metadata">

**Author:** ![NFNHello](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nfnhello/32/3371_2.png) [@NFNHello](https://community.glideapps.com/u/NFNHello)\
**Post date:** [December 13, 2022, 1:22am UTC](https://community.glideapps.com/t/sum-via-rollup-tips/55678/3 "2022-12-13T01:22:42Z")

</div>

This may not apply exactly to what you are doing, so take what works for you and leave the rest.

When I have a need to have a conditional SUM, I create a relation based off of an ITE column and then use a rollup based off of that relation. The rollup only sums the records captured within the relation, and I haven’t had any issues with formatting.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 13, 2022, 1:49am UTC](https://community.glideapps.com/t/sum-via-rollup-tips/55678/4 "2022-12-13T01:49:53Z")

</div>

I don’t understand. Can you give an example with screen shots?