Hi,
I have need of a computed column in a datawindow that should result a number Or null.
I understand that in Script I can use SetNull(SomeVariable) easily, but cannot find in Expression functions
that can do the same.
example: If( state_code ='NY' , 100, SetNull(0) )
or If( state_code ='NY' , 100, Null )
any function that can produce a Numreric Value or null result.
Thanks.
And 'No' to the usage question, I will not be using this in any other computed field or calculations.
So I created a global a function to return null and use it expression as John suggested.
I have done this in past by another technique where create datawindow argument, pass argument as null, the use that variable name in expression.
Thanks.