Max outcome

Hi,

The code will depend of your equation, in this case you should use conditional statements. For example, if your current equation is: fieldname1+fieldname2, you should edit it like follow:

(function(){
var r = fieldname1+fieldname2;
return IF(r>=1000,999,r);
})()

Best regards.

Hi,

Thanks but unfortunatally that code doesn’t work when I put it there.
I tried:
(function(){
var r = fieldname10*50+fieldname11*3+fieldname8;
return IF(r>=1000,999,r);
})()

And I tried
(function(){
var r = fieldname10+fieldname11+fieldname8;
return IF(r>=1000,999,r);
})()

And my Set Equation is:
fieldname10*50+fieldname11*3+fieldname8

Almost there, I hope.
Do you see what I am doing wrong?

Kind Regards

Sorry, it works great now! I did’nt understand I needed to put it in the Set Equation field.
Thanks!!

Excellent!!!!

Best regards.