1 Reply Latest reply on Feb 2, 2013 3:55 PM by Alex Kerin

    Replacing Null with Value from Another Column

    brian.johnston.0

      I am trying to create a dimension called Agency which could include one of two columns.  If one column has a null value, I want to replace it from the other column which will not be null.  I am using a clauclated column with the below functions, however, it is not working right.  It is only populating the alc value and not the ro.  any help you can provide would be awesome!

       

       

      IIF (isnull([alc_number]),[ro_number],[alc_number])