SELECT() not working as I expected

[JordanJed]

I am trying to total a column with a constraint based on the UNIQUE ID of another table. I have a column that copies the UNIQUE ID from table 1 to a row with the column I want included in the calculation. I have a similar calculation going the other way, which works. I am not getting an error, but I expect the same answer.

This does not work:

SUM(SELECT(TIPS_MAHWAH[AMOUNT],[REF TO REC SHEET]=[REF TO REC SHEET].[UNIQUEID_REC],TRUE))

Going the other way works:

SUM(SELECT(TIPS_MAHWAH[AMOUNT],[UNIQUEID_REC]=TIPS_MAHWAH[UNIQUEID_TIPS].[REF TO REC SHEET],TRUE))

[Marc_Dillon]

1. Can you show the table setup for the tables in question?
2. You probably need to use [_THISROW] on one side of your select condition equality.
3. https://community.appsheet.com/t/referencing-a-column-value-in-a-table-versus-referencing-all-column...

[JordanJed]

No need to post. This worked. Thank you!  I'm still not following the logic 100%, but I am getting there.