Financial functions

I'm currently using EXP(SUM(LOG(field))) like a PRODUCT function. I need to take the number of the query to a power. The actual tsql is:

EXP(SUM(LOG(LOAD_Performance_Peers.CALC_Performance)))-1

I need to take the result to the power of 12/60 ( an annualization for 5 years)

POWER(EXP(SUM(LOG(LOAD_Performance_Peers.CALC_Performance))), 12/60)-1

Does not work. Any ideas? Thanks
mfonyAsked:
Who is Participating?
 
virtuadeptCommented:
Are you getting an error message?

Also what if you change the 12/60 part to 12.0/60.0?  It may be trying to do an integer division there.
0
 
mfonyAuthor Commented:
Correct about the integer division.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.