Cannot compare List with Number

[Sebastian_Rosse]

I have a table [Productos] with a column “ID product” Number, and a colum “Uni. Compra” number.

I have a table [Detalles] with a column “ID product” Ref and a colum “Cantidad” Number

I want in table [Productos] column “Uni. Compra” to get SUM of “Cantidad” from the other table but I get this error:

Cannot compare List with Number

What am I doing wrong?

[Marc_Dillon · Accepted solution]

Referencing a Column value in a Table, versus referencing ALL Column values in the entire Table Tips & Tricks 💡

Having answered this question about 1 million times now, I guess I should make a tips-and-tricks post about it. Expressions of the form Table[Column] return a List type data value that contains the values in Column for ALL records in the entire Table. Most likely, If I’ve referred you to this post, the answer to your question is simply to change it to just: [Column] One of the most common places I’ve seen new app builders use this, is within SELECT() expression, like: SELECT( Table[Col…

[Sebastian_Rosse]

Referencing a Column value in a Table, versus referencing ALL Column values in the entire Table

u can freely replace “Table” with the name of any Slice and expressions work the same way, but only reference records from the Slice instead of the entire Table.

I can’t believe it was so easy. I had read many questions on the same subject but had not gotten the nuance. Thank you.