• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Need help with calculation

New Here ,
Sep 16, 2024 Sep 16, 2024

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??

 

 

TOPICS
PDF forms

Views

105

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Expert , Sep 16, 2024 Sep 16, 2024

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.

 

 

Votes

Translate

Translate
Community Expert ,
Sep 16, 2024 Sep 16, 2024

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.

 

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Sep 17, 2024 Sep 17, 2024

Copy link to clipboard

Copied

LATEST

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines