Home » SQL & PL/SQL » SQL & PL/SQL » FractionalAgents (Oracle 11G)
FractionalAgents [message #626186] Wed, 22 October 2014 08:54 Go to next message
samrams
Messages: 1
Registered: October 2014
Junior Member
Hi,

I am looking for a function called fractionalAgents which is used to calculate the FTE (Full Time Equivalent) needed based on 4 parameters. This is a widely used function for forecasting. We have add-on in Excel for this.

Do we have any sort of direction to achieve the same in PL/SQL?

We are using Oracle 11G database version.

Thanks

Sam

[Updated on: Wed, 22 October 2014 08:55]

Report message to a moderator

Re: FractionalAgents [message #626195 is a reply to message #626186] Wed, 22 October 2014 10:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It may be well-known for you but it is unknown from me, maybe if you explain what are the inputs, the output and on what the function works we can help you to do it in PL/SQL.

Re: FractionalAgents [message #626197 is a reply to message #626186] Wed, 22 October 2014 10:27 Go to previous messageGo to next message
John Watson
Messages: 8929
Registered: January 2010
Location: Global Village
Senior Member
You will probably have to write the function yourself. There are people here who will help, if you provide the algorithm, and have a go yourself first. Then you can present it at Open World, and be famous.
Re: FractionalAgents [message #626209 is a reply to message #626197] Wed, 22 October 2014 12:35 Go to previous message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
The formula is fairly simple and is shown on the following link

http://www.anfponline.org/Resources/DMAResources/calculate_FTEs.shtml

Try to write it your self. If you can't show us what you tried and we will give you a hand.
Previous Topic: need sql query
Next Topic: SET Autocommit XXXX
Goto Forum:
  


Current Time: Fri Apr 19 21:41:33 CDT 2024