Procedure returns char instead of Number

[haste]

I have textfield that gets it values from a procedure. The prob is the returns a string instead of number. Its as follows:

function TOT_VALFormula return Number is
begin
RETURN ( NVLINVI_VALUE,0)- :CF_DISC_VAL );
end;

The result I get is something like:

16551 - 2000

I have checked the text field data type and its set to Number. Am running form 6i.

 

[lewisp]

Assuming you have created the function in the porgram units section of forms builder, I have cut and pasted your code into a form and created text items as you have described. I cannot get a result other than 14551 in my target field.

Are you sure your function isnt overloaded?

 

[haste]

Found the problem the record group that the function gets its values from is based on a query with a UNION. The query in this instance is returning rows from both SELECTs.