Hey just to let you know I got around this problem in a very blunt way by creating a table in my Oracle application to mimic the 33 seperate queries needed. It ain't pretty but its pretty robust.
I will roll out this application soon using my less than perfect solution and when my plate clears...
I'm 110% sure there is Alex :) :lol: Yes it helps.... very much! It is being written in HTMLDB/ Application Express, which as you rightly say is a middleware/ front end for deploying web apps reading from Oracle.
Here is the select query.
select
(D2004 /(POWER((1 + (:DISC_1/100)),(2004 -...
Alex thanks.
I've only got as far as writing 33 different queries for each possible value of Y2, which will be between 2003 and 2036. This approach will be fine but I need help getting this one to run as well.
So I have a value for Y2 which will trigger one of 33 possible queries. How can I...
Ok I have the following variables
Discount Rate (R) - A static user defined value
demand (D) - the result of a query
base year (Y1) - 2003
future year (Y2) - user entered and needs to count backward to base year
I need the following formula to execute
NPD = D/ (1+R)^(Y2-Y1)
and iterate...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.