Calculate x - y then if result is < 0, enter 0
I would start by searching the forums.
Have you considered using the Math.max method?
Will do - thanks
This a a calculation
for a local tax form ( I work
I can do the subtraction -
But then if the amount is
less than 0 - they must enter 0
on the form.
I’ve searched the forums and
tried a few things they showed -
Still having problem - but will keep
If you post the actual field names we can help you with the code...
Line 7 of the Local Tax Form says:
7. Total Taxable Net Profit (Subtract Line 6 from Line 5. If less than zero, enter zero) .
I did the subtraction -
NetProfit - NetLoss
But don't know how to set the result (TotalTaxNP) to 0 if it is < 0
if NetLoss > NetProfit, then TotalTaxNP = 0
Use this code as the custom calculation script of your field:
var v1 = Number(this.getField("NetProfit").valueAsString);
var v2 = Number(this.getField("NetLoss").valueAsString);
event.value = Math.max(0, v1-v2);
It works! – am looking for the place to click ‘Correct’ -
The script works - thank you so much