Hello @susp3nc3
I’m sorry, but I feel I need more information to answer your question. Could you please include your current equation and describe how you want to modify it?
Best regards.
1.) If fieldname15 reaches 28 or more, then 16,000 be added to fieldname78
2.) fieldname19-MIN((fieldname8+fieldname9)*fieldname19, fieldname7)
If fieldname7 value is hit I am trying to get fieldname79’s value to be multiplied by any addition units in fieldname15 over fieldname7’s value.
3.) fieldname19-MIN((fieldname8+fieldname9)*fieldname19, fieldname7)
If fieldname7 value is reached then $400 to be added to fieldname78
4.) if fieldname15 is greater than 1, $200 to be added to fieldname78
Any help is greatly appreciated.
Hello @susp3nc3
There are some ambiguities in your description. I’m not sure if the four points describe the same equation. Or if the text “If fieldname7 value is reached then $400 to be added to fieldname78” refers only to the operand MIN((fieldname8+fieldname9)*fieldname19, fieldname7). But if it is the case, the equation would be similar to:
(function(){
var result = 0;
if(1<fieldname15 && fieldname15<28) result += 200;
else if(28 <= fieldname15) result += 16000;
if(MIN((fieldname8+fieldname9)*fieldname19, fieldname7) == fieldname7) result += 400;
return result;
})()
Best regards.
Looks like a lot of it is working!
Looks like when the 28 number is reached on field 15 the 16,000 adds to the field, however $200 is removed as well. The 200 is there after 1< and 400 works after the fieldname7 amount, but when 28 is reached in fieldname15 it removes 200 after adding 16,000.
Hello @susp3nc3
In this case, you can edit the equation as follows:
(function(){
var result = 0;
if(1<fieldname15) result += 200;
if(28 <= fieldname15) result += 16000;
if(MIN((fieldname8+fieldname9)*fieldname19, fieldname7) == fieldname7) result += 400;
return result;
})()
Best regards.
Amazing! Thank you for the info. I think I have figured out how to do most everything I need now. Where can I donate?
