Sorry - I am sure this is probably an easy question but I cannot for the life of me figure it out. I am trying to get the following statement to work. It shows up as 'valid' but when I pull the field over to rows, only"null' shows up. I know there are instances where the individual ids are equal (indiv ID is a number in both instances and in the dimensions field). I can't show an example unfortunately because of confidentiality issues.
IIF(ATTR([indv_id (copy)])=ATTR([Sheet1 (XYZ.xls)].[indv_id (copy)]), 'Yes', 'No')
I assume you have [indv_id (copy)] as the columns or at least on the Level of Detail shelf?
Assuming yes, another thought: [indv_id (copy)] used in the worksheet might need to be from the same data source as the calculated field. ...