Custom or Conditional Column

[bdehning]

I currently have a custom column for Determining Reporting Location with the following.   

[Reporting Location Address1]&", "&[Reporting Location City]&", "&[Reporting Location State]&", "&[Reporting Location Zip Code]

I need to introduce a statement if "Reporting Location is "blank", replace with "Not Specified"

Can I add that to the Custom Column or should I introduce a Conditional Column to accomplish this?

[bdehning · Accepted solution]

 I ended up creating A conditional Column and added a step to replace null with Not Specified.  I will try Merge Columns ion my next one.  

[Ashish_Mathur]

Hi,

I think you should do this in the Query Editor.  Use the Merge columns feature there.

[bdehning]

The original Custom Column returns a null value, which shows up using term Blank in the visual.  

[Seanan]

Hi @bdehning 

You can add this as a custom column using the following code:

IF([CustomCol1] = BLANK(),"Not Specified",[CustomCol1])

[bdehning]

It keeps saying error on the IF and not recognized.

IF([Reporting Location] = BLANK(), "Not Specified", [Reporting Location])

[Seanan]

Hi @bdehning 

Does your Reporting Location column return the a blank name or the actual text "Blank"?

If you following these steps you should get your desired outcome:

If your column returns text "Blank" then use:

IF([Reporting Location] = "Blank", "Not Specified", [Reporting Location])

If the cell value is empty then use:

IF([Reporting Location] = BLANK(), "Not Specified", [Reporting Location])

It should look like this:

If it is still returning an error could you please post a picture of your calculated column with the error message.