[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Financial functions

Posted on 2013-02-06
2
Medium Priority
?
301 Views
Last Modified: 2013-02-06
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
0
Comment
Question by:mfony
2 Comments
 
LVL 8

Accepted Solution

by:
virtuadept earned 2000 total points
ID: 38861253
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
 

Author Comment

by:mfony
ID: 38861438
Correct about the integer division.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question