number() function stops convert strings with letters
Hello, I think that function number(), was converting strings like "XX23" to number 23... I've used it lot to convert record id to number for function record(Table,number(id)) .
What happend that number() is not workin as it was? What I can do ? All formulas are now returning 0 !!!
To my knowledge, this has never worked to convert a string that contains letters as well as numbers into a number. The result was always 0. It is different if you apply number to the record ID as follows: (select TABLENAME where FIELD=xy).number(id).
But you can solve it as follows: