Sum with other table

[Jaimy]

Hi,

I want to add two values together. One value is from the Employees table I'm creating the action in and the other is from a different table called Hours, I'm getting this error however. How would I select only the value of hours where the Id in Employee = Employee column in Hours?

Hours Table:

[Yogi_Hayate]

Hi Jaimy, 

Have you try Select function? 

SELECT(Hours[Hours],
([Your target ID] = [_THISROW].[Your ID))

for further information, try to learn from appsheets blog
https://help.appsheet.com/en/articles/2357314-select

[Aurelien]

Hi @Jaimy 

Something like that ?

SUM([Related Hours])