Endif prevents formcalc process

[NY2CA]

I finally figured out how to remove the syntax errors with endif. The problem is now I have no more errors and those fields no longer calculate.

Example for a loan payment: The field requires other fields to calculate so "endif" was needed. The other fields are zero until I fill the form.

if(Pmt>0) then Pmt(LoanTotal, Blendrate / 1200, Term * 12) (Taxes + Ins + HOA)endif

Payment calculated perfectly prior to "endif" as follows. (LoanTotal, Blendrate / 1200, Term * 12) (Taxes + Ins + HOA)

Not sure how this can be fixed? The form works great, but I hate all the syntax errors.

Thanks.

[whyisthisme · Accepted solution]

the if condition should be something like:

if (LoanTotal > 0 and Blendrate > 0 and Term > 0) then

otherwise you would get a division by 0 error.

[NY2CA]

Thank you for the help! the code below is what  i've placed in the calulate event in formcalc. It still doesnt work. Is it becuase Ignored the Taxes, ins and HOA?

If(Pmt > 0 and Blendrate > 0 and Term > 0) then Pmt(LoanTotal , Blendrate / 1200, Term * 12) + Taxes + Ins + HOA;

endif.

Is there a way to do equal (=) to or greater than(>) also?

[NY2CA]

I figured out the greater than or equal to thing. Still working on the Pmt.

Thanks again.

[NY2CA]

Got it working, thank you! Now lets see if if can get the color coded properly.