Home » Developer & Programmer » Reports & Discoverer » error using a formula column
error using a formula column [message #345394] Wed, 03 September 2008 06:46 Go to next message
Messages: 251
Registered: May 2008
Senior Member
i am trying to calculate sal / 12 in a formula column

so i said in my formula column

return (:sal / 12)

but it says bind variable sal is not allowed

function CF_1Formula return Number is
  return (:sal / 12);

Re: error using a formula column [message #345406 is a reply to message #345394] Wed, 03 September 2008 07:44 Go to previous messageGo to next message
Messages: 28
Registered: May 2007
Location: Surat,India
Junior Member
hello dear,
I what to know in which group your formula column field is?
Is it with same group of :sal field? and :sal is number field?
Are you getting any ora or rep error number with this?
Also give information about which version of report and database u using with which operating system.
Re: error using a formula column [message #345409 is a reply to message #345394] Wed, 03 September 2008 07:50 Go to previous message
Messages: 21130
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Just being curious: why are you calculating it using a formula? Why wouldn't you do that in report's query, such as
  sal/12 salary_divided_by_12
FROM some_table
Previous Topic: Character mode Print
Next Topic: How to design reports tat wil print details in Alternative page
Goto Forum:

Current Time: Tue Jul 25 16:11:58 CDT 2017

Total time taken to generate the page: 0.19378 seconds