Help for Total loam amount

Hi,

What version of the plugin are you using?

The CALCULATEAMOUNT operation is part of the financial module included only with the Developer and Platinum versions of the plugin. If you are using one of these versions of the plugin, and the fields corresponding to the Monthly payments, rate and number of months are the fieldname1, fieldname2, and fieldname3 respectively, the equation associated to the calculated field would be as simple as:

CALCULATEAMOUNT(fieldname1,fieldname2,fieldname3)

Best regards.

Hi,

Our plugin allows to use all javascript instructions in the equations, the different modules, like: date/time, financial, distance, etc. facilitates the implementation of the equations, but if you have knowledge about the javascript programming language, you can implement your own operations.

Best regards.

Hi,

Yes, you should select the calculated field, and enter the equation in the “Set Equation” textarea, for example, if your equation is as simple as the sum of two fields: fieldname1, and fieldname2 the equation would be:

fieldname1+fieldname2

however if the equation is complex, you should use the “function” structure:

(function(){
var result = fieldname1+fieldname2;
return result;
})()

Tip: Remember to return a result that will be displayed as the calculated field value.

Best regards.

Hi,

You shouldn’t define parameters in the function:

(function(){
var result = 0;
if(fieldname7 == 0){
result = fieldname2 * fieldname8;
}
else{
var i = fieldname7/100/12,
i_to_m = POW(i + 1, fieldname8),
a = fieldname2 / (i * i_to_m) / (i_to_m - 1));
result = ROUND(a * 100) / 100;
}
return result;
})()

The structure now is correct, but from this support thread, I cannot check the values of the form’s fields.

Best regards.

Hi,

The fields’ names are generated dynamically and cannot be modified, however, you can insert multiple forms in the same page, that won’t be conflict between their fields, each equation uses only the fields corresponding to its form.

Could you send me the link to your webpage to check the form in action, please?

Best regards.

Hi,

There are some issues in your equation. Your current equation is:

(function(){
	var result = 0;
	if(fieldname7_2 == 0){
		result = fieldname2_2 * fieldname8_2;
	}
	else{
		var i = fieldname7_2/100/12,
		    i_to_m = POW(i + 1, fieldname8_2),
		    a = fieldname2_2 / (i * i_to_m) / (i_to_m - 1));

		result = ROUND(a * 100) / 100;
	}
	return result;
})()

Remove the _2 from the fields’ names, furthermore in the piece of code: a = fieldname2_2 / (i * i_to_m) / (i_to_m - 1)); there is an extra right parenthesis “)”

The correct equation is:

(function(){
	var result = 0;
	if(fieldname7 == 0){
		result = fieldname2 * fieldname8;
	}
	else{
		var i = fieldname7/100/12,
		    i_to_m = POW(i + 1, fieldname8),
		    a = fieldname2 / (i * i_to_m) / (i_to_m - 1);

		result = ROUND(a * 100) / 100;
	}
	return result;
})()

If you need additional help to implement your equations, I can offer you a custom coding service through the following link:

http://cff.dwbooster.com/customization

Best regards.

Hi,

Enter the space character into the “Prefix” attribute of the calculated field.

Best regards.