Adding Null value symbology?

[AndreasB]

Hi, 

I have a symbology which is set through two attributes using unique values.

For example the values would be
800,100
801,100

in my database there is a combination of this two fields with a <Null> value 
For example: 800; <Null> and this is picked up in the symbology when I do, add all values 

Now I also want to add 801; <Null> to this symbology posibilities, now this combination is not present yet in the attribute table but could be in the future.

Yet when I try to do this via the "add values" option in the symbology pane I always get an error:

I tried several different options of null, " ", , Null, <Null> but nothing works
The field from the <Null> is a numeric long integer field. How can I add this to the list??

[Ed_]

• Maybe change the Null column to text then
• right click on the Value (data type text) column and open the "Calculate Field" tool
• select Arcade or Python whatever works for you 
• 
• apply the symbology again
• For testing purposes I created a dummy table where Value1 is long and Value4 is text so I manually typed in <Null>
•  

[DavidSolari]

Make a copy of the feature class, ensure it has the same symbology as the source layer, add records which contain the values you want to symbolize, add those options to the unique values, configure the symbols, save this to a layer file, apply this layer file to the source layer, delete the copy. Boom, you're ready for future data without tampering with the production features!

[clt_cabq]

Does using the term Nothing instead of Null work? In calculations where you want to make a field's value  null you use an expression like  'FieldName = Nothing' so this makes me wonder if that will work here. 

[AndreasB]

Nothing didn't work unfortunatly.

I'm currently working with map services that are read only so I can't temper with the data. 

I mainly to know why it does get taken into account when it's in the attribute table but when the combination is not and you want to add it you get a warning that this value is not allowed.