If-function else-clause not recognizing missing values
If I add an If-function to a column, the else-clause does not recognize empty values (see attached sheet). this means that the function:If( :Column 2 == 1, 1,2 )leaves missing values if Column 2 contains missing values. I can fix this by changing the function to:If( :Column 2 == 1, 1, Is Missing( :Column 2 ), 2)orIf( :Column 2 == 1, 1, Is Missing( :Column 2 ), 2, 2)but why is this necessary?...
