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

Percentage calculation

New Here ,
Apr 29, 2018 Apr 29, 2018

Copy link to clipboard

Copied

I need to enter the calculations on a .pdf form and I am having trouble getting the percentages to work.

I have a Property Value (field 4.3) then a Borrowers Equity (field 4.6) and then a Percentage of Equity (field 4.7)

What Java Script would I use to get the percentage to come out correctly (example 20.0%)

TOPICS
Acrobat SDK and JavaScript , Windows

Views

423

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
LEGEND ,
Apr 29, 2018 Apr 29, 2018

Copy link to clipboard

Copied

LATEST

What is the problem you are having?

I would start by reviewing the Acrobat JavaScript tutorials abut performing calculations and acquainting myself with the syntax for Acrobat JavaScript.

How to do (not so simple) form calculations​  by Thom Parker

I would them make sure the fields I am going to use have the correct formatting for the expected type of input or write some custom validation. I would set field 4.3 and 4.6 to have a format of Number with the appropriate number of decimal places. For field 4.7 I would use the Percentage format.

Acrobat provides 3 methods for entering calculations. The first one is for selecting fields to perform a specific calculation but division is not one them, so the method is not available.

Them there is the Simplified Field notation that uses just the field names and assumes you are using the value of the fields or a constant value. This method requires a specific field naming convention and the first requirement is that all field names start with an alphabetic character. Since your field names do not follow this requirement, you cannot use this method.

The last option is to use the Custom JavaScript  code to write the script. To use a field's value one needs to get the field object by the field name and them use the value property. The example computes the decimal of the sum of 2 numbers divided by a third number. This is very similar to the calculation for computing a percentage when the result field is set to the Percentage format. The result of this calculation will give one a value that can be used without any conversion in any other calculation, It is the decimal value used for the Percentage. Acrobat forms uses the Percentage format to only change the displayed value. If one needs the result to be limited to to 3 decimal places, one for display purposed, then one will need to add a founding function.

Note you you may have to deal with division by a divisor with a value of zero or near zero..

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