Convert Missing Numeric to Char
When converting a missing Numeric value to Char, Char() will return ".". Is there a simple way to return ""?
(I know I can wrap with If( Is Missing( )), but this seems unnecessarily cumbersome.
New Table( "Missing Numeric to Char",
Add Rows( 1 ),
New Column( "Numeric", Numeric, "Continuous", Format( "Best", 12 ), Set Values( [.] ) ),
New Column( "Is Numeric Missing?", Numeric, "Continuous"...