Simple IF Statement

I have a field called "NetCash". If this value of "NetCash" is less than 0, then in another field called "Available" I need to return the value 0.

If the value in the "NetCash" field is greater than 0, then I need to return the actual value of the "NetCash" field in my "Available" field.

Please can you help me?

Many thanks

This topic has been closed for replies.

Community Expert

Use this code as the custom calculation script of "Available":

var netCash = Number(this.getField("NetCash").value);

event.value = Math.max(0, netCash);

Sign up