IF Return Calculation

Hello @cfalco

There are some issues in your equation:

First, in javascript the operator for equality is double sign: “==”, because the sign “=” is used for assignment.

Second, in javascript the textual values must be enclosed between single or double quotes.

Third, in javascript the “AND” operator is represented with the double sign: &&

So, the correct equation would be:

(function(){
if(fieldname11=='male' && fieldname14==0) return fieldname2*12*18.40;
})();

or using the “AND” operation distributed with the plugin:

(function(){
if(AND(fieldname11=='male', fieldname14==0)) return fieldname2*12*18.40;
})();

Best regards.

Hello @cfalco

You can reduce the complexity, at least in the execution, nesting the “if” conditional statements:

(function(){
    if(fieldname11=='male')
    {
        if(fieldname14==0) return fieldname2*12*18.40;
        else return fieldname2*12*17.20;
    }
    else
    {
        if(fieldname14==0) return fieldname2*12*20.85;
        else return fieldname2*12*20.10;
    }
})();

Best regards.

Hello @cfalco

Your use of the javascript conditional statement “if” is invalid (more information in the link: https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Statements/if…else). The correct would be:

(function(){
	var result;
    if(fieldname11=='male')
    {
        switch(fieldname14)
		{
			case 0:
				result = fieldname2*12*18.400;
			break;	
			case 1:
				result = fieldname2*12*18.389;
			break;
			case 2:
				result = fieldname2*12*18.374;
			break;
			default:
				result =  fieldname2*12*18.357;
			break;
		}
	}
    else
	{
		switch(fieldname14)
		{
			case 0:
				result = fieldname2*12*18.464;
			break;	
			case 1:
				result = fieldname2*12*18.456;
			break;
			case 2:
				result = fieldname2*12*18.443;
			break;
			default:
				result =  fieldname2*12*18.430;
			break;
		}
	}	
	return result;
})();

You can nesting “if” conditional statements, I’ve decided to use the “switch” one to implement a more optimized equation(https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Statements/switch)

If you want to use this result in another field, you are free to do it. You can use a calculated field in the equations of other calculated fields. The only restriction is take care of don’t generate an infinite loop (using the field A in the equation of field B, and the field B in the equation of field A).

For example, assuming the previous field is the fieldname123, and you want to sum it to the value of the fieldname456 field.

Note: the fields’ names are hypothetical.

You simply should to insert another calculated field in the form with the equation:

fieldname123+fieldname456

and that’s all.
Best regards.

Hello @cfalco

If you want to sum a fixed value to the result, for example, the number 12345, you simply should to edit the line of code in the equation:

return result;

as follows:

return result+12345;

Concerning to the decimal places. If you want to control the number of decimal places in the result, you should use the PREC operation: PREC(X,Y) returns the number X with Y decimal places.

So assuming you want the result has only two decimal places, edit the previous line of code as follows:

return PREC(result+12345, 2);

and that’s all.
Best regards.