Calculate x - y then if result is < 0, enter 0

[jyoho107]

Calculate x - y then if result is < 0, enter 0

[gkaiseril]

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?

[jyoho107]

Will do - thanks

Judy

[jyoho107]

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

[try67]

If you post the actual field names we can help you with the code...

[jyoho107]

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

[try67 · Accepted solution]

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);

[jyoho107]

It works! – am looking for the place to click ‘Correct’ -

[jyoho107]

The script works - thank you so much