# “Average Total” value from computed columns not sorting numerically on leaderboard

**URL:** <https://community.glideapps.com/t/average-total-value-from-computed-columns-not-sorting-numerically-on-leaderboard/85218>\
**Category:** Ask for Help\
**Created:** [November 1, 2025, 6:18pm UTC](https://community.glideapps.com/t/average-total-value-from-computed-columns-not-sorting-numerically-on-leaderboard/85218 "2025-11-01T18:18:38Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ptcsac](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ptcsac/32/92673_2.png) [@ptcsac](https://community.glideapps.com/u/ptcsac)\
**Post date:** [November 1, 2025, 6:18pm UTC](https://community.glideapps.com/t/average-total-value-from-computed-columns-not-sorting-numerically-on-leaderboard/85218/1 "2025-11-01T18:18:38Z")

</div>

Hi everyone,

We’re almost finished building our app for a judging event, but we’re running into an issue with sorting computed numeric values on our leaderboard.

Here’s our setup:

- Judges fill out a **form** that scores each team on several criteria (numeric values).
- Those criteria are totaled in a **Math column** (“Total Score”) for each team per judge.
- Another table uses a **Rollup** to collect all “Total Scores” for each team, and another Rollup to count how many entries there are.
- A **Math column** divides the total scores by the number of entries to get an average.
- An **If-Then-Else column** (“Average Total Safe”) replaces blank averages with 0, otherwise keeps the average value.

The “Average Total Safe” values correctly appear on our leaderboard table — however, **Glide doesn’t recognize them as numbers** , so we can’t **sort by the average total**. The only way to make sorting work is to manually copy those values into a separate **Number column** (or export and re-import), which isn’t feasible since this needs to update live during the event.

Has anyone found a way to make an If-Then-Else or Rollup/Math-derived column be recognized as a number for sorting in real time?

Thanks in advance!

---

<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:** [November 1, 2025, 7:59pm UTC](https://community.glideapps.com/t/average-total-value-from-computed-columns-not-sorting-numerically-on-leaderboard/85218/2 "2025-11-01T19:59:07Z")

</div>

Try adding zero to it with a Math column, that should coerce it back to a numeric value.

---

<div class="post-metadata">

**Author:** ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)\
**Post date:** [November 1, 2025, 11:52pm UTC](https://community.glideapps.com/t/average-total-value-from-computed-columns-not-sorting-numerically-on-leaderboard/85218/3 "2025-11-01T23:52:29Z")

</div>

Hey,

You can also use a math column and use If-then-else column on it to convert it into a number. Hope the screenshot helps.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/7/170e3191426c67d2a8f08905c18d4ce2f633eff6.png)