Copy link to clipboard
Copied
Calculate x - y then if result is < 0, enter 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);
Copy link to clipboard
Copied
I would start by searching the forums.
This action will require a custom JavaScript so the exact field names will be required.
Have you considered using the Math.max method?
Copy link to clipboard
Copied
Will do - thanks
Judy
Copy link to clipboard
Copied
This a a calculation
for a local tax form ( I work
with AARP)
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
trying
Thanks again
Judy
Copy link to clipboard
Copied
If you post the actual field names we can help you with the code...
Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
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);
Copy link to clipboard
Copied
It works! – am looking for the place to click ‘Correct’ -
Copy link to clipboard
Copied
The script works - thank you so much