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!
Are you sure you have a real NULL and not the word "NULL"?