[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 299
  • Last Modified:

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
0
mfony
Asked:
mfony
1 Solution
 
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now