Skip to main content
L
lindac27335921
Participating Frequently
October 25, 2019
Answered

im trying to calculate a number divided by 3

  • October 25, 2019
  • 4 replies
  • 1085 views

in my form i have a 6 fields  

 

total units          70561255

divide by 2    35280628.5     to get this answer i had to use the average   

divide by 3                            i cant figure out the formula to get the answer   

 

here is what it should be like from execl 

Total Units Divided By Units
70,561,255 2 35,280,627.5
  3 23,520,418.3

so the adobe form is a fill in the form with numbers that we add up get a sub + sub total = grand total

 

than we take the grand total and divide by 2 or 1/2 to get that total 

then we take the grand total and divide by 3 or 1/3 to get that total

 

i know this sounds easy i have it correct in excel but how do i do this in adobe form in the properties calculated field?

 

thank you for your assistance

all replies and assistance will be appreciated

 

Ms Linda Carter

 

[E-mail removed by moderator.]

(Moved from Get Started to the Acrobat forum by Mod JSM)

    This topic has been closed for replies.
    Correct answer try67

    As the custom calculation script of the Units field enter the following JavaScript code:

     

    event.value = Number(this.getField("Total Units").valueAsString) / 3;

    4 replies

    try67
    Community Expert
    try67Community ExpertCorrect answer
    Community Expert
    October 26, 2019

    As the custom calculation script of the Units field enter the following JavaScript code:

     

    event.value = Number(this.getField("Total Units").valueAsString) / 3;

    L
    lindac27335921Author
    Participating Frequently
    October 27, 2019

    Thank you so very much for the script as it worked perfect.  You’re an angel

     

    Now all my numbers, totals and sub totals work perfect

     

    Ms Linda Carter

    L
    lindac27335921Author
    Participating Frequently
    October 25, 2019

    Using Acrobat pro 2017
    I know the calculation works in execl but the question is how do I make this calculation work it acrobat pro 2017on my form.

    Just Shoot Me
    Just Shoot Me
    Legend
    October 25, 2019

    I believe you have stumbled into the wrong support forum site.

    You probably want the MS Excel forum and or some other Spread Sheet software forum.

     

    If this does have something to do with software created and or sold by Adobe then please post the software name.

    L
    lindac27335921Author
    Participating Frequently
    October 25, 2019

    The software I am using is acrobat pro 2017. 

    I want to use the same calculations I get an execl and make them work on my Acrobat pro Adobe form 

    In the calculation field In the properties box what is the Syntax or formula that can be accepted to make the form get the same answer I get in execl?   

    I built a fill in the blank form soThat I enter the numbers all the calculations are displayed with all the right totals

    Nancy OShea
    Community Expert
    Nancy OSheaCommunity Expert
    Community Expert
    October 25, 2019

    Which Adobe software or service is this related to?

    This is a public user forum.  For your protection, I removed the e-mail address from your post so you don't get a bunch of spam mail.

    Nancy O'Shea— Product User & Community Expert
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices