All Forums Database
dhanred 4 posts Joined 11/04
27 Jun 2006
How to calculate exponential values.

Hi all,I have a calculation that has to do the followingTotal Amount = ColumnA* { [1 + (columnB/100) ] ^30 }^ = to the power of Is there a function in teradata that we can use to calculate exponential values( I have tried 'EXP' but its on for a standard values of '2.714')RegardsDhanred

dhanred 4 posts Joined 11/04
28 Jun 2006

Hi,I have found that we do not have a function in teradata to do exponential calculations.It can be acheived as followsTotal Amount = ColumnA* { [1 + (columnB/100) ] ^30 } can be calculated asTotal Amount = ColumnA* ( (1 + (columnB/100) ) ** 30 ).Just by using * twice.

You must sign in to leave a comment.