1 Reply Latest reply on Jan 31, 2013 1:24 AM by Jim Wahl

    Issue with IIF statement

    jen green

      Hi there


      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')


      Any thoughts?