Totals in table

1

Hello everyone,

I can’t figure out how to fill my (sub)total colum in a table. When I group and summarize on items, I can see the result that I am looking for, like 18 hammers. But I would like to get that number in the total column, so that in both PO rows the number 18 would show up.
Anyone any idea? Sample doc:

Thanks in advance,
Joost

2

HI Joost.

Are you looking for something like the below?

image
image1202×617 31.9 KB

There is an example in the page Mathematics Formulas in Tables in my examples doc:

3

I thought about this one.

thisTable.Filter(Items.Contains(thisRow.Items)).Qty.Sum()

image
image2557×1734 280 KB

cheers, Christiaan

2 Likes
4

Hello @Piet_Strydom ,
Thank you for your reply. Your samples are a bit different from what I need, bus inspiring nevertheless.
Greetings,
Joost

5

Good morning @Christiaan_Huizer ,
Thanks - I am wondering why I didn’t get this to work, but that is exactly what I need. I think I used match and ‘=’, now that I have a working sample I will try all the variations and better my understanding of Coda a bit more.
Greetings,
Joost

1 Like
6

hi Joost, the moment you see that searching through a column means running through a list of items in that column you work best with a Contains() variation in your filter and you are set.

cheers! Christiaan

1 Like