problem with POWER(x,y)

[luzippu]

hi,

i can't see why the following field is not working correctly, ie: it's always coming up with 0:

((POWER((1+((((((POWER((1+(dbo_table1.APR/100)),(1/12)))-1))*12))/12)), dbo_table1.FREQUENCY)-1)*(12/dbo_table1.FREQUENCY))*100 AS YIELD

breaking the code down to a smaller formula it does work.

it looks like i can't have more calculations/references inside a POWER(x,y) function.

any comments would be appreciated.

thank you

 

[bborissov]

Your select get alll integers, try this:

((POWER((1.0+((((((POWER((1.0+(dbo_table1.APR/100.0)),(1/12.0)))-1))*12))/12)), dbo_table1.FREQUENCY)-1.0)*(12.0/dbo_table1.FREQUENCY))*100.0 AS YIELD

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[luzippu]

fantastic
thank you