Personalization, Customization and Productivity Tools

[bob47301]

Hi All,  I am having an issue with creating a calculated field in BI Explorer.   I need to use a UDF that is a string and am attempting to convert it this way: {fn Number("SO_SalesOrderHeader"."UDF_CLOSING")} , which is accepted ok (even though it is not on the function list) but if I try to add it with any other fields I get an error.   Is there a way to convert it that will not give an error or do I need to recreate the UDF as a number?

Thanks!

Bob

[BShockley]

tonumber({field name}

[bob47301]

ToNumber is not a valid expression in BI Explorer  (fn Number works up to a point..