How to calculate exponential values.

Database

How to calculate exponential values.

Hi all,

I have a calculation that has to do the following

Total 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')

Regards
Dhanred
1 REPLY

Re: How to calculate exponential values.

Hi,

I have found that we do not have a function in teradata to do exponential calculations.
It can be acheived as follows

Total Amount = ColumnA* { [1 + (columnB/100) ] ^30 } can be calculated as

Total Amount = ColumnA* ( (1 + (columnB/100) ) ** 30 ).

Just by using * twice.