Reply
Member
Posts: 61
Registered: ‎03-13-2018

Custom Column Country Name

Hi,

Can anyone help with this?

 

I appended the Sales & International Sales Table.

Then added the custom Column by this formula below to add Country Name column.

But the "null" value is not replacing with "USA"

 

Thanks!Edx Cstom Column.PNG

 

Regular Visitor
Posts: 43
Registered: ‎08-19-2016

Re: Custom Column Country Name

Instead of:

 

[Country] = "null"

 

use:

 

[Country] = null

 

The former will only return True when [Country] is a literal string: "null"

Member
Posts: 61
Registered: ‎03-13-2018

Re: Custom Column Country Name

Thank you so so much!!! @jeffshieldsdev...It worked Smiley Happy

 

Regards,

panda2018