Calculate compound interest EXP

Hi,

The EXP operation evaluates E^x, where E is Euler’s number (approximately 2.7183), and X is the parameter passed to the operation.

Your equation has a little issue, the correct would be:

fieldname4*(1+fieldname3)*exp(fieldname2)

Best regards.

Hi

This is not working.

I want to calculate this:
Total end capital= capital now*(1+Interest rate)^(time period)

You understand what i mean?

Example:

In math 7^4= 2401

I want to calculate: (capital now)^capital now*(1+Interest rate)

(fieldname4)^fieldname2*(1+fieldname3)

Hi,

The operation you are needing is the “POW” operation:

7^4 is represented as: POW(7,4)

So, fieldname4^fieldname2 is represented as: POW(fieldname4,fieldname2)

Best regards.

Thank you very much this will work.

I have another question about the POW function.

Can this pow function do complicated mathematical formulas?

I need to calculate this:

PMT * [ ( ( 1 + i )^N – 1 ) / i ]

I doesn’t work when i put it in a calculate field like this:

(((POW(1+fieldname1,fieldname4)-1)/fieldname1)*fieldname2)

So my question is: how can i calculate this right?
( 1 + i )^N

Hi,

The structure of your equation is fine:

(((POW(1+fieldname1,fieldname4)-1)/fieldname1)*fieldname2)

But be careful with the field values, if the value of fieldname1 field is zero, the equation will generate a mathematical error ( x/0 = error )

In this case you should use conditional operations like follow:

IF(fieldname1 != 0,(((POW(1+fieldname1,fieldname4)-1)/fieldname1)*fieldname2), ” )

Best regards.