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

How to work with formula's in Adobe DC Pro

Community Beginner ,
Oct 04, 2023 Oct 04, 2023

Copy link to clipboard

Copied

I have attached my file, that I am trying to do a few items in.

 

Issue one: I want to be able to get the average of "Guys" on the bottom of my form.

Issue two: I want the "Days" to be the "Total Hrs" /  "Guys" = Total Days

Issue three: I want the individual rows of Guys * Days *10 = Total Hours. Example 3 guys * 3 Days * 10 = 90 Hours So that way on the Total Hours on the bottom give me a complete total and then populate the Issue number two above. In excel I can do this with no problem.


I appreciate any help I can get.

TOPICS
How to , JavaScript , PDF , PDF forms

Views

558

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
Community Expert ,
Oct 04, 2023 Oct 04, 2023

Copy link to clipboard

Copied

What have you already done to implement these calculations?

See these articles:

https://acrobatusers.com/tutorials/how-to-do-not-so-simple-form-calculations/

Look at the sample PDF. Built-in and Simplified Notation can be used for all the calcs

 

https://www.pdfscripting.com/public/Calculating-field-values-and-more.cfm

 

 

Thom Parker - Software Developer at PDFScripting
Use the Acrobat JavaScript Reference early and often

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
Community Beginner ,
Oct 04, 2023 Oct 04, 2023

Copy link to clipboard

Copied

I know how to create forms, and know how to do the basic totaling of columns. Beyond that is new to me. I generaly use excel for all my formulas. 

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
Community Expert ,
Oct 04, 2023 Oct 04, 2023

Copy link to clipboard

Copied

LATEST

Hence the articles:

 

Thom Parker - Software Developer at PDFScripting
Use the Acrobat JavaScript Reference early and often

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