mfony
asked on
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_Performan ce_Peers.C ALC_Perfor mance)))-1
I need to take the result to the power of 12/60 ( an annualization for 5 years)
POWER(EXP(SUM(LOG(LOAD_Per formance_P eers.CALC_ Performanc e))), 12/60)-1
Does not work. Any ideas? Thanks
EXP(SUM(LOG(LOAD_Performan
I need to take the result to the power of 12/60 ( an annualization for 5 years)
POWER(EXP(SUM(LOG(LOAD_Per
Does not work. Any ideas? Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER