Using a sum for a colum in a table lookup

[paolotaverna]

Good day, hope all is well, 

I am trying to make a sum of a column in a lookup table depending on the id (right now I hard coded the id for testing purpose).

I have tried many formulas but it doe not seem to work.  see my pluck image. 

Please help 🙂  I would like to avoid looping on the table. 

[Prudvi]

Hi @paolotaverna,
what is the data type of the variable temo_1.
If its integer you might have to use to_i
if its float you might have to use to_f
Regards,
Prudvi