IF Statement

Hello @namazee,

You simply should use the “MAX” operation. I’ll try to describe the process with an example, assuming that there are two fields: fieldname1 for volumetric weight and fieldname2 for actual weight, the equation would be:

MAX(fieldname1,fieldname2)

Best regards.

i used it but it doesn’t seems to detect the MAX

(function(){
MAX(fieldname32,fieldname28);

if(fieldname32 <= 3) return 51.00;
if(fieldname32 > 3) return 51.00 +(fieldname32-3) *16;

})();

Hello @namazee,

I’m sorry, but that equation has no sense. You should assign the value returned by the MAX operation to a variable, and then, use this variable in the conditional statements and mathematical operations, as follows:

(function(){
var m = MAX(fieldname32,fieldname28);
if(m <= 3) return 51.00;
return 51.00+(m-3)*16;
})();

Best regards.

why this code doesnt function in my calculation ?

(function(){

if(fieldname4==1){

if(fieldname5==”sponge”){

if(fieldname2>=0.8 || fieldname2<1.1)
fieldname1=75.00;
else if(fieldname2>=1.1 || fieldname2<1.5)
fieldname1=85.00;
else if(fieldname2>=1.5 || fieldname2<1.8)
fieldname1=95.00;
else if(fieldname2>=1.8 || fieldname2<2.2)
fieldname1=110.00*quantity;
else if(fieldname2>=2.2 || fieldname2<2.5)
fieldname1=130.00;
else if(fieldname2>=2.5 || fieldname2<3.0)
fieldname1=160.00;
}

else
{
if(fieldname2>=0.8 || fieldname2<1.1)
fieldname1=95.00;
else if(fieldname2>=1.1 || fieldname2<1.5)
fieldname1=110.00;
else if(fieldname2>=1.5 || fieldname2<1.8)
fieldname1=125.00;
else if(fieldname2>=1.8 || fieldname2<2.2)
fieldname1=145.00;
else if(fieldname2>=2.2 || fieldname2<2.5)
fieldname1=170.00;
else if(fieldname2>=2.5 || fieldname2<3.0)
fieldname1=205.00*quantity;
}
}

else if(fieldname4==2)

if(fieldname5==”sponge”))
fieldname1=170.00;
else
fieldname5=220.00;

else

if(fieldname==”sponge”)
fieldname1=295.00;
else
fieldname1=390;

return fieldname1;

})();

Hello @sitisarahothman,

There are multiple issues in your equation:

– First in this piece of code the field’s name is wrong: if (fieldname == "sponge") the fields’ names have the structure: fieldname#

– Second, the plugin replaces all texts with the structure: fieldname# with the corresponding field’s value, so, all pieces of code with the format: fieldname1=#; (like fieldname1 = 75.00; fieldname1 = 85.00; fieldname1 = 95.00; ….) are invalid, because you cannot assign a number to a number.

– Third, you are using a variable in the equation called: quantity, that is not being defined at least in the equation.

– Fourth, there are nested condition statements (“if”) that are ambiguos, in this cases you should use the symbols {} to solve the ambiguity and delimit the code that corresponds to each of them.

Best regards.