Need help with calculation

[marge_8457]

Very new to Adobe!!  I have a form that I am working on that I need help with from you awesome, more experienced people!  🙂

I have a field, total3 that is the sum of other fields.  (works perfect) I have another field, total6, that I need to be total3 divided by 6 IF total3 is greater than 300.  If total3 is less than 300, then total6 would be zero.

Any takers to help me out??

[PDF Automation Station · Accepted solution]

Enter the following custom calculation script total 6:

var ttl3=this.getField("total3").value;

if(ttl3>300)

{event.value=ttl3/6}

else

{event.value=0}

This does not cover when ttl 3 is exactly 300.  If you want 300 included in the greater than statement us >=.  If you want the 300 result to be zero, leave as is.

[marge_8457]

Thank you so much!!  Worked like a charm.  🙂