Home » RDBMS Server » Server Administration » Formula to work out 30% of a given field/cost
Formula to work out 30% of a given field/cost [message #373640] Fri, 27 April 2001 19:15 Go to next message
kari
Messages: 1
Registered: April 2001
Junior Member
How can i get a value to be displayed that is 30% of a given cost. Thishas to be displayed on a report and i dont know what coding to enter and where abouts when in the layout editor, any help would be greatly appreciated. many thanks

Report message to a moderator

Re: Formula to work out 30% of a given field/cost [message #373642 is a reply to message #373640] Sat, 28 April 2001 07:02 Go to previous message
Venkat
Messages: 110
Registered: February 2001
Senior Member
In a formula columns

select (:givencost /(decode(nvl(:cost,0),0,1,:cost) * 0.3
from dual

Report message to a moderator

Previous Topic: Re: OPTIMIZE QUERY
Next Topic: SQL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 10:06:15 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.