Copy link to clipboard
Copied
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??
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
Thank you so much!! Worked like a charm. 🙂