Hi,
I am trying to encode in a Sigma ( summation ) series into an Oracle sql query ( as opposed to pl/sql ). I am not sure if this is possible ? I cannot find a function in Oracle that would give me this.
I am trying to model ∑ p(1+r)^i
For the series i=0 to n ( r in this case is a rate value of 0.5 – in this case it is a constant but could in future be a variable )
Its actually a formula not disimiliar to compound interest calculation ( except it would be a summation of the compound interest values - hence the use of Sigma )
any help appreciated,
Jim