Calculate based on the value of another field and leave blank if other field is blank

Question

I am looking for some help with form field calculations .

1. I need to multiply "TGAI" * 0.03 , but if "MedicalExpenses" is empty then leave return the value of "0".

this field, when calculated needs to return a negative value

2. If "HPW" AND "WPY" are blank then leave cell blank if "HPW" AND "WPY" have values then multiply "HW" * "HPY"

Thank you for any help you can provide.

PDF Automation Station · Accepted Answer

That worked , thank you so much , now i just have one more issue on this form and im done with it .

if you dont mind taking a look when you get a chance i would really appriciate it .

I have left notes on the form and included the entire worksheet this time for your reference .

Again , thank you for your time

if(!this.getField("GMI.0").value)
{event.value=25}
else
{event.value=this.getField("Calc_TotalMonthlyPayment").value-this.getField("Utilities").value}

PDF Automation Station · Answer

1.

if(!this.getField("MedicalExpense").value)

{event.value=0}

else

{event.value=this.getField("TGAI").value * .03 * -1}

2.

if(this.getField("HPW").value && this.getField("WPY").value)

{event.value=this.getField("HPW").value * this.getField("WPY").value}

else

{event.value=""}

Inscrivez-vous

Login social

Bienvenue

Login social

Analyse virus du fichier

Ce fichier ne peut pas être téléchargé