formula column error [message #89226] |
Wed, 10 December 2003 04:51 |
Jasmine
Messages: 23 Registered: December 2000
|
Junior Member |
|
|
when i am creating an formula column to calculate
for eg
fun calc
begin
return (sales * rate);
end;
its returning both sales and rate r not defined its the column
name of the table that selected how to write for formula
i used bind variable
:sales and :rate
but it showing errors
how to overcome can any body give one eg
thanks in advance
jasmine
|
|
|
Re: formula column error [message #89227 is a reply to message #89226] |
Wed, 10 December 2003 08:06 |
ram kumar
Messages: 113 Registered: August 2002
|
Senior Member |
|
|
function CF_1Formula return Number is
begin
return(:sal*:comm);
end;
those sal and comm colums must be there in select statement
THE FORMULA CODE SHOULD LOOK LIKE ABOVE
rAM
|
|
|
|