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))
LinkedIn
Twitter
