Copy link to clipboard
Copied
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%
Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
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
Find more inspiration, events, and resources on the new Adobe Community
Explore Now