# Rollup Average Issue on Big Table

**URL:** <https://community.glideapps.com/t/rollup-average-issue-on-big-table/76955>\
**Category:** Report a Bug\
**Tags:** big-tables\
**Created:** [October 9, 2024, 3:07pm UTC](https://community.glideapps.com/t/rollup-average-issue-on-big-table/76955 "2024-10-09T15:07:04Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![GT\_Formation](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gt_formation/32/29598_2.png) [@GT\_Formation](https://community.glideapps.com/u/GT_Formation)\
**Post date:** [October 9, 2024, 3:07pm UTC](https://community.glideapps.com/t/rollup-average-issue-on-big-table/76955/1 "2024-10-09T15:07:04Z")

</div>

Hello,  
I have a problem in Big Table with a “Rollup” column that calculates the average of a “Math” column with a simple calculation ( (a+b+c)/d ).

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

I’m supposed to have the same result, since the average is based on a single note…

Does anyone have the same problem?

---

<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 10, 2024, 12:00am UTC](https://community.glideapps.com/t/rollup-average-issue-on-big-table/76955/2 "2024-10-10T00:00:31Z")

</div>

Can you show us how you’re configuring those 2 columns? What are you rolling up and what’s the relation with the math column?

---

<div class="post-metadata">

**Author:** ![GT\_Formation](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gt_formation/32/29598_2.png) [@GT\_Formation](https://community.glideapps.com/u/GT_Formation)\
**Post date:** [October 10, 2024, 7:45am UTC](https://community.glideapps.com/t/rollup-average-issue-on-big-table/76955/3 "2024-10-10T07:45:15Z")

</div>

My “math” column is an average of 3 notes. My “rollup average” is based on an auto-relation that allows me to average over several rows.

 ![Capture d'écran 2024-10-10 093711](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/d/ed585dd37a3a650b4c3df863f6f7e3113ff14b80.png)  
 ![Capture d'écran 2024-10-10 093759](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/1/619a1e647dfb8dd8bb2bb2f83f83060048e4fe86.png)

---

<div class="post-metadata">

**Author:** ![GT\_Formation](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gt_formation/32/29598_2.png) [@GT\_Formation](https://community.glideapps.com/u/GT_Formation)\
**Post date:** [October 10, 2024, 8:37am UTC](https://community.glideapps.com/t/rollup-average-issue-on-big-table/76955/4 "2024-10-10T08:37:18Z")

</div>

[https://www.loom.com/share/f9b3de95d63f4db7a88ac019ad1c7984?sid=3d6add78-7cdb-4b2a-9dce-b68ee0c574a4](https://www.loom.com/share/f9b3de95d63f4db7a88ac019ad1c7984?sid=3d6add78-7cdb-4b2a-9dce-b68ee0c574a4)

---

<div class="post-metadata">

**Author:** ![GT\_Formation](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gt_formation/32/29598_2.png) [@GT\_Formation](https://community.glideapps.com/u/GT_Formation)\
**Post date:** [October 10, 2024, 2:10pm UTC](https://community.glideapps.com/t/rollup-average-issue-on-big-table/76955/5 "2024-10-10T14:10:05Z")

</div>

For those who have had the same problem, it’s about the format of the cell and the comma when exporting/importing.

---

<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:** [October 17, 2024, 2:10pm UTC](https://community.glideapps.com/t/rollup-average-issue-on-big-table/76955/6 "2024-10-17T14:10:30Z")

</div>

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