Need help for formula

Hello @alicexwarehouse

There are some issues in your formula. In javascript the decimal symbol is the dot and not the comma.

Furthermore, javascript is a case-sensitive language. You can use the “IF” operation distributed with the plugin, whose structure is: IF(condition, result if condition is true, result if condition is false). Or you can use the “if” conditional statement of javascript whose structure is different.

So, the formula can be implemented as follows:

IF(0 < fieldname1, IF(60000 <= fieldname1, (fieldname1 - 60000) * 0.01526 + 1675.79, IF(17000 <= fieldname1, (fieldname1 - 17000) * 0.02034 + 801.17, IF(6500 <= fieldname1, (fieldname1 - 6500) * 0.03051 + 480.81, fieldname1 * 0.07397))), 0)

or you can implement it with function structure and “if” conditional statements as follows:

(function(){
	if(fieldname1<0) return 0;
	if(fieldname1<6500) return fieldname1 * 0.07397;
	if(fieldname1<17000) return (fieldname1 - 6500) * 0.03051 + 480.81;
	if(fieldname1<60000) return (fieldname1 - 17000) * 0.02034 + 801.17;
	return (fieldname1 - 60000) * 0.01526 + 1675.79;
})()

Best regards.

Hello @alicexwarehouse

Yes, of course. Please, use the PREC operation as the outermost operation in the equation. PREC(X,Y) rounds the number X with Y decimals.

For example:

PREC(IF(0 < fieldname1, IF(60000 <= fieldname1, (fieldname1 - 60000) * 0.01526 + 1675.79, IF(17000 <= fieldname1, (fieldname1 - 17000) * 0.02034 + 801.17, IF(6500 <= fieldname1, (fieldname1 - 6500) * 0.03051 + 480.81, fieldname1 * 0.07397))), 0), 2)

or

PREC((function(){
	if(fieldname1<0) return 0;
	if(fieldname1<6500) return fieldname1 * 0.07397;
	if(fieldname1<17000) return (fieldname1 - 6500) * 0.03051 + 480.81;
	if(fieldname1<60000) return (fieldname1 - 17000) * 0.02034 + 801.17;
	return (fieldname1 - 60000) * 0.01526 + 1675.79;
})(),2)

Best regards.