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

PDF Calculations with multiple options/choices

New Here ,
Jun 27, 2024 Jun 27, 2024

Please help! I have been searching for similar logic but couldn't find any in previous discussion.

 

I need to calculate "CommissionTotal" based on "CommissionValue" (established amount) multiplied by "CommissionTier", which has 5 options:

CommissionTier1 = 50%

CommissionTier2 = 65%

CommissionTier3 = 75%

CommissionTier4 = 80%

CommissionTier5 = 85%

TOPICS
JavaScript , PDF , PDF forms
357
Translate
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
1 ACCEPTED SOLUTION
Community Expert ,
Jun 27, 2024 Jun 27, 2024
LATEST

If "CommissionTier" is dropdown field, set percentage as export value, for example:

for CommissionTier1 set export value 0.5

for CommissionTier2 set export value 0.65

...etc

 

For simple multiplications you can use built in calculations, under 'Calculate' tab select 'Value is the', select 'product(x) and pick "CommissionValue" and "CommissionTier" fields, or you can use 'Simplified field notation' just enter field names:

CommissionValue*CommissionTier

 

 

 

 

 

View solution in original post

Translate
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
Adobe Employee ,
Jun 27, 2024 Jun 27, 2024

Hi there

Hope you are doing well and thanks for reaching out.

The workflow you are trying to achieve is might be possible using JavaScript. For more information please check the help pages listed below:
https://acrobatusers.com/tutorials/javascript_console/
https://helpx.adobe.com/acrobat/using/applying-actions-scripts-pdfs.html

Hope it will help

Regards
Amal

Regards
Amal
Translate
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 ,
Jun 27, 2024 Jun 27, 2024
LATEST

If "CommissionTier" is dropdown field, set percentage as export value, for example:

for CommissionTier1 set export value 0.5

for CommissionTier2 set export value 0.65

...etc

 

For simple multiplications you can use built in calculations, under 'Calculate' tab select 'Value is the', select 'product(x) and pick "CommissionValue" and "CommissionTier" fields, or you can use 'Simplified field notation' just enter field names:

CommissionValue*CommissionTier

 

 

 

 

 

Translate
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