# How to should sum of price of all orders in customer table

**URL:** <https://community.nocodb.com/t/how-to-should-sum-of-price-of-all-orders-in-customer-table/1482>\
**Category:** Formulas\
**Created:** [November 17, 2024, 2:48am UTC](https://community.nocodb.com/t/how-to-should-sum-of-price-of-all-orders-in-customer-table/1482 "2024-11-17T02:48:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![averactbe](https://avatars.discourse-cdn.com/v4/letter/a/54ee81/32.png) [@averactbe](https://community.nocodb.com/u/averactbe)\
**Post date:** [November 17, 2024, 2:48am UTC](https://community.nocodb.com/t/how-to-should-sum-of-price-of-all-orders-in-customer-table/1482/1 "2024-11-17T02:48:04Z")

</div>

I have table `Order` in which I have column `Final price` which is a formula field.  
Now `Orders` quantity is shown in customer column.  
I want another column `Customers` table to show total sum of all `order.totalPrice` for that customer.  
Rollup field in `Customers` is not showing any formula field of orders. So right now I am not able to sum up the final price.

---

<div class="post-metadata">

**Author:** ![dstala](https://avatars.discourse-cdn.com/v4/letter/d/f04885/32.png) [@dstala](https://community.nocodb.com/u/dstala)\
**Post date:** [November 18, 2024, 6:53am UTC](https://community.nocodb.com/t/how-to-should-sum-of-price-of-all-orders-in-customer-table/1482/2 "2024-11-18T06:53:48Z")

</div>

If you can share a screenshot of the schema or provide a link to a shared base, we can help. Following kinds of aggregations are currently possible.

- Rollup
- Column aggregations
- Column aggregations at GroupBy Level