[Resolved] Expression Function error when returning NA values
I have a problem with an Expression Function.
The function returns a Real; when the first value of the output column is "NA", Spotfire considers the column to contain Booleans, and thus it is impossible to create the calculated column using the Expression Function. The error message is: "TERR script [...] did not return the expected type Real instead returned Boolean."
As a workaround, I put a dummy value in place of the first returned value (in case it's "NA")...
Interestingly, once the calculated column is created, I can modify the code of the Expression Function and make it return "NA" values even for the first value, and it works!
It appears to me that this is a bug; I'm using Spotfire 22.214.171.124. Any advice most welcome!