Sum filtered from another table

1

Hello community,

I am basically trying to filter a list. This seems easy but i’m clearly missing a point somewhere.

I have a table of orders referencing a client and listing a price for the order.
I have a table of clients where I want to have the total of all orders per clients and the number of orders per clients.
And there is something wrong with my filter formula for the total per client.
My count formula is working though. So I thought I understood the syntax…

Any help will be greatly appreciated.
Thanks

2

Dear @Eric_Munier,

The syntax is as below, the first to count the orders and the second the total amount of the orders

Orders.filter(Client=thisRow).Order.count() 

Orders.Filter(Client=thisRow).Price.Sum()

The way Coda works is:

Look in the table [orders] filter the (Client=thisRow) and then in case of:

the order; count how many orders there have been made.

the price, give the sum for all amounts under “Price”

image
image832×530 22.7 KB

image
image883×525 22.3 KB

2 Likes
3

so simple.
Thanks so much @Jean_Pierre_Traets