4 Replies Latest reply on Jun 1, 2013 6:05 PM by Matt Lutton

    Replacing Null Value Help?

    Matt Lutton

      I read about replacing null values using the IFNULL and ISNULL functions, but am not having much luck.  It may be due to the way my data sources are blended (this is what I suspect but I do not know why).

       

      Scenario:  Show coaches for students in a cross tab.  Change null values to "N/A"

       

      What I did:  Used calculated field:

      IFNULL([Coach], 'N/A')

       

      Also tried:

      IIF(ISNULL([Coach] ), 'N/A', [Coach] )  <-- I believe this should have the same solution as above.

       

      I am still getting Null and * in my column.  Screenshot below:


      NullValues.jpg

      Any ideas?  Thanks to all!