Total Calculation with maximum value

Hello,

Assuming your current equation is for example: fieldname1+fieldname2, you can edit it as follows:

(function(){
var r = fieldname1+fieldname2;
return IF(r<=100,r,'The warning message here');
})()

and that’s all.
Best regards.

Hello,

Assuming your calculated field is the fieldname3, the equation can be edited as follows:

(function(){
  var r = fieldname1+fieldname2;
  if(r<=100){
    jQuery('[id*="fieldname'+'3_"]').css('color','black');
    return r;
  }else{
    jQuery('[id*="fieldname'+'3_"]').css('color','red');
    return 'The warning message here';
  }
})()

If you need additional help implementing your equations, we can offer you a custom coding service from our private website:

https://cff.dwbooster.com/customization

Best regards.