# Sub Items calculations

**URL:** <https://connect.superhuman.com/t/sub-items-calculations/54300>\
**Category:** Ask the Community\
**Created:** [February 27, 2025, 8:51pm UTC](https://connect.superhuman.com/t/sub-items-calculations/54300 "2025-02-27T20:51:38Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Phil\_Purdy1](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/phil_purdy1/32/18795_2.png) [@Phil\_Purdy1](https://connect.superhuman.com/u/Phil_Purdy1)\
**Post date:** [February 27, 2025, 8:51pm UTC](https://connect.superhuman.com/t/sub-items-calculations/54300/1 "2025-02-27T20:51:38Z")

</div>

I have a table I would like to use as an estimator. I would like the parent row to gather the totals of the Sub Item rows and apply that to the parent row calculation. What is the best way to accomplish this?

 ![image](https://global.discourse-cdn.com/coda1/original/3X/b/d/bd9fc1bc3c2513ae6f8ab8b60e4b202e3eb09f22.png)

---

<div class="post-metadata">

**Author:** ![Pablo\_DV](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pablo_dv/32/49028_2.png) [@Pablo\_DV](https://connect.superhuman.com/u/Pablo_DV)\
**Post date:** [February 28, 2025, 2:05am UTC](https://connect.superhuman.com/t/sub-items-calculations/54300/2 "2025-02-28T02:05:03Z")

</div>

Have you considered grouping by parent row without subitems and using the summarize function? I think that you could get something similar to what you want that way.

But if you really want to keep everything in a single table and make use of the subitems, I can only offer you this not very elegant approach.

Assuming that you only have 1 level of subitems and only those contain raw data, you would need 2 columns for each of the fields you want to calculate:

- Raw data: Empty for all items that are not subitems
- Calculated: If(thisRow.Subitems.IsBlank(),thisRow.[Raw Data],thisRow.Subitems.[Raw Data].Sum())

Hide all the ‘Raw data’ columns and create a conditional form rule to make parent rows bold.

https://coda.io/embed/lore4NNI1u?viewMode=embedplay#_tu6qp/r60&view=full

Hope this helps,

Pablo

---

<div class="post-metadata">

**Author:** ![Phil\_Purdy1](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/phil_purdy1/32/18795_2.png) [@Phil\_Purdy1](https://connect.superhuman.com/u/Phil_Purdy1)\
**Post date:** [March 3, 2025, 4:43am UTC](https://connect.superhuman.com/t/sub-items-calculations/54300/3 "2025-03-03T04:43:20Z")

</div>

I actually found the solution in another thread.

> [@Formule chez les parents de Sub Items](https://connect.superhuman.com/t/formule-chez-les-parents-de-sub-items/52906):
>
> Hello, I first do apologize for my bad English as a French beginner in Coda. Is it possible to have the Sum of a Sub Item’s value (or an another formula) in the same Column of the Parent’s one ?

This formula calculates the total of all the sub items in under the parent row as another column. I then changed my client and cost totals to include the subitem total plus the calculated total.

It works pretty nice for an estimator.

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [June 1, 2025, 4:44am UTC](https://connect.superhuman.com/t/sub-items-calculations/54300/4 "2025-06-01T04:44:10Z")

</div>

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