# Could not get Average or Sum in Rollup column **URL:** \ **Category:** Ask for Help\ **Created:** [January 19, 2024, 12:11pm UTC](https://community.glideapps.com/t/could-not-get-average-or-sum-in-rollup-column/69748 "2024-01-19T12:11:22Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![smaxss](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/smaxss/32/61057_2.png) [@smaxss](https://community.glideapps.com/u/smaxss)\ **Post date:** [January 19, 2024, 12:11pm UTC](https://community.glideapps.com/t/could-not-get-average-or-sum-in-rollup-column/69748/1 "2024-01-19T12:11:22Z")
Hi, I have the JSON column to return a value between 1 and 9. Ok, I presume it might be considered text, so I have used another MATH column and converted it to Int using the T function. I could see the decimals, so I presume it is a number. Then, I used another table relationship to select the transactions per month/year. I used the look-up function and can see the values that I need. However, I could not use the Rollup function on this array to give me the AVERAGE. I tried using QURY on the Relationship, still can only see the COUNTs I can only see Count and Count Unique. What Am I doing wrong here? ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [January 19, 2024, 1:37pm UTC](https://community.glideapps.com/t/could-not-get-average-or-sum-in-rollup-column/69748/2 "2024-01-19T13:37:20Z")
If you’re only seeing count and count unique something isn’t a number. Could we see a screenshot of your setup? ---
**Author:** ![smaxss](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/smaxss/32/61057_2.png) [@smaxss](https://community.glideapps.com/u/smaxss)\ **Post date:** [January 19, 2024, 3:14pm UTC](https://community.glideapps.com/t/could-not-get-average-or-sum-in-rollup-column/69748/3 "2024-01-19T15:14:42Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/8/48b1586c4aaa1fd4dc8cdea37f421e2d6b893f0f.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/7/278b7b311ec90cdeb866d2f98cc663d4ea3a4499.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/9/e921f98b68f3de428bb115e0f864587dd2825370.png) I have uploaded a few screenshots to illustrate the example. I agree it does not seem to recognise a number, but at the same time, why does it add decimals, then? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 19, 2024, 3:58pm UTC](https://community.glideapps.com/t/could-not-get-average-or-sum-in-rollup-column/69748/4 "2024-01-19T15:58:12Z")
It might be because you are trying to use the Lookup column in your Rollup. You shouldn’t need the Lookup column, as a Rollup can work directly through the relation. ---
**Author:** ![smaxss](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/smaxss/32/61057_2.png) [@smaxss](https://community.glideapps.com/u/smaxss)\ **Post date:** [January 19, 2024, 4:27pm UTC](https://community.glideapps.com/t/could-not-get-average-or-sum-in-rollup-column/69748/5 "2024-01-19T16:27:28Z")
True, I tried both ways - the same effect ☹ Could it be a bug? ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [January 19, 2024, 4:31pm UTC](https://community.glideapps.com/t/could-not-get-average-or-sum-in-rollup-column/69748/6 "2024-01-19T16:31:04Z")
I agree with what Jeff said but also you need to do something in the configuration of the math column… to force it to a number I.e T\*1 ---
**Author:** ![smaxss](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/smaxss/32/61057_2.png) [@smaxss](https://community.glideapps.com/u/smaxss)\ **Post date:** [January 19, 2024, 4:34pm UTC](https://community.glideapps.com/t/could-not-get-average-or-sum-in-rollup-column/69748/7 "2024-01-19T16:34:59Z")
Super! this worked! How silly of me not to think about this small thing Thank you, Eric ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [January 19, 2024, 4:37pm UTC](https://community.glideapps.com/t/could-not-get-average-or-sum-in-rollup-column/69748/8 "2024-01-19T16:37:23Z")
Happy to help! Thanks for the screens 🕶 ---
**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:** [January 26, 2024, 4:38pm UTC](https://community.glideapps.com/t/could-not-get-average-or-sum-in-rollup-column/69748/9 "2024-01-26T16:38:04Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.