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

Formula question

New Here ,
Mar 01, 2019 Mar 01, 2019

Copy link to clipboard

Copied

How can I get the field called Net After Tax to show the sum of Net x Tax (which is a %) and not just what the tax is?

TOPICS
Acrobat SDK and JavaScript

Views

179

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 ,
Mar 01, 2019 Mar 01, 2019

Copy link to clipboard

Copied

It appears you want to calculate the sum of the field Net and the result of the calculation of the fields Net times Tax.

This can be done using the Simplified Field Notation

Net + (Net * Tax)

or

Net * (1 + Tax)

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 ,
Mar 01, 2019 Mar 01, 2019

Copy link to clipboard

Copied

It's not a sum, it's a product...

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
LEGEND ,
Mar 01, 2019 Mar 01, 2019

Copy link to clipboard

Copied

LATEST

You may also need to deal with rounding of the calculation since most extensive tax calculations round the results of a calculation to 2 decimal places. While Acrobat forms may display the rounded calculation amounts the actual value of the computed fields will extend to many more decimal places and these values beyond the 2 decimal places can change the result of calculations being performed after the tax calculation. The applying of rounding a calculated amount to actual field value cannot be done in the Simplified Field Notation.

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