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? 

      Thanks!!!