Skip to main content
Participant
June 27, 2024
Answered

PDF Calculations with multiple options/choices

  • June 27, 2024
  • 2 replies
  • 496 views

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%

This topic has been closed for replies.
Correct answer Nesa Nurani

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

 

 

 

 

 

2 replies

Nesa Nurani
Community Expert
Nesa NuraniCommunity ExpertCorrect answer
Community Expert
June 28, 2024

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

 

 

 

 

 

Amal.
Legend
June 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