# Calculate total of a split list

**URL:** <https://community.glideapps.com/t/calculate-total-of-a-split-list/61318>\
**Category:** Ask for Help\
**Created:** [May 3, 2023, 11:37pm UTC](https://community.glideapps.com/t/calculate-total-of-a-split-list/61318 "2023-05-03T23:37:35Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Matty\_Fenny](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matty_fenny/32/39419_2.png) [@Matty\_Fenny](https://community.glideapps.com/u/Matty_Fenny)\
**Post date:** [May 3, 2023, 11:37pm UTC](https://community.glideapps.com/t/calculate-total-of-a-split-list/61318/1 "2023-05-03T23:37:36Z")

</div>

Hi,

I am looking for a way to calculate the sum of all values in a single cell. This is for a jobsheet app and ill try and explain:

Engineer fills out a custom form and completes a job. This job has a job price column.

Using a relations I have created a List of all the prices of completed jobs for a single user.  
I have then made a Split list of this list to seperate the values.

I now need to add all of the values in the split list together.

This is basically to see how much an engineer has made the company.

Thanks,

Matty.

---

<div class="post-metadata">

**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:** [May 3, 2023, 11:50pm UTC](https://community.glideapps.com/t/calculate-total-of-a-split-list/61318/2 "2023-05-03T23:50:20Z")

</div>

There’s a simpler way. All you should need is a Rollup Column that uses the relation.

---

<div class="post-metadata">

**Author:** ![Matty\_Fenny](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matty_fenny/32/39419_2.png) [@Matty\_Fenny](https://community.glideapps.com/u/Matty_Fenny)\
**Post date:** [May 3, 2023, 11:51pm UTC](https://community.glideapps.com/t/calculate-total-of-a-split-list/61318/3 "2023-05-03T23:51:12Z")

</div>

Ok, I was being Dumb.

I was wondering why Rollup was only letting me do “Count”.

My Job Price was a Text Column instead of number.

So now I just have a rollup that calculates the Sum of all of the Job prices of the Jobs completed by an engineer.

---

<div class="post-metadata">

**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:** [May 3, 2023, 11:52pm UTC](https://community.glideapps.com/t/calculate-total-of-a-split-list/61318/4 "2023-05-03T23:52:54Z")

</div>

Ahh, yeah that would do it. It has to be a numeric column. Glad you figured it out.

---

<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:** [May 4, 2023, 11:53pm UTC](https://community.glideapps.com/t/calculate-total-of-a-split-list/61318/5 "2023-05-04T23:53:20Z")

</div>

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