Hello @ita21
Please, describe your equation and send me the link to your form.
Best regards.
Thread Starter
ita21
(@ita21)
The equation is this:
prec((fieldname2*fieldname7/1200*pow(1+fieldname7/1200,fieldname8)-fieldname7/1200)/(pow(1+fieldname7/1200,fieldname8)-1),2)
I want the fieldname7 to accept also 0 as value,
Hello @ita21
The value of the fieldname7 field cannot be zero because the equation’s component: (pow(1+fieldname7/1200,fieldname8)-1) would be equal to zero, and in mathematics, the division by zero is invalid.
However, if the interest is zero, you would pay the principal only. So, if the principal in your form is the fieldname2 field, the equation would be similar to:
PREC(IF(fieldname7, (fieldname2*fieldname7/1200*pow(1+fieldname7/1200,fieldname8)-fieldname7/1200)/(pow(1+fieldname7/1200,fieldname8)-1), fieldname2), 2)
Best regards.
Thread Starter
ita21
(@ita21)
Thanks,
Yes I understand this (would be equal to zero, and in mathematics, the division by zero is invalid) but can we make it to pay the principal divided by month for example if I take 10.000 $ with 0% and I choose to pay for 10 months to display as monthly rate result: 1000$
Hello @ita21
In this case, if the number of months is the fieldname8, you should edit the equation I sent you previously as follows:
PREC(IF(fieldname7, (fieldname2*fieldname7/1200*pow(1+fieldname7/1200,fieldname8)-fieldname7/1200)/(pow(1+fieldname7/1200,fieldname8)-1), fieldname2/fieldname8), 2)
Best regards.
