Skip to main content
Participating Frequently
April 19, 2020
Answered

Need Help Calculating Based on the Value from a Drop-Down List

  • April 19, 2020
  • 1 reply
  • 1538 views

Hello Again!! 

I have two more form fields that need custom calculations and I don't even know how to begin writing these correctly. Would someone please help me out with the calculations below? 

 

First Calculation: I have a Drop-Down Field "LAPUsed" that has only two possible choices: Yes or No [Note that in order for me to center these I had to put several spaces in front so the actual values are "           Yes" & "            No" (11 spaces in front of Yes & 12 spaces in front of No) - Not sure if that's relevant or not]

Back to the problem:

a) If the "LAPUsed" Drop-Down value is Yes then I need the text field "TotalofWaivedPayments" to show the Product of "BasePayment" x "#ofPaymentsWaived"

b) If the "LAPUsed" Drop-Down value is No then I need the text field "TotalofWaivedPayments" to input $0.00 (or just 0 since my field is formatted)

 

Second Calculation: This is similar to the first Calculation, however just a couple more steps and different fields invovled. I have another Drop-Down Field "DispoFeeWaived" that also can only be Yes or No (Same amount of spacing as above so I could center the values)

Problem:

a) First Scenario: I need the text field "EstimatedCharges" to calculate the following:

"TotalofRemainingPayments" minus "TotalofWaivedPayments", then add "AmountofExcessMileageDue", & lastly add the "DispoFee" if the "DispoFeeWaived" Drop-Down value is No.

b) Second Scenario: I need the text field "EstimatedCharges" to calculate the following:

"TotalofRemainingPayments" minus "TotalofWaivedPayments", then add "AmountofExcessMileageDue", & if the "DispoFeeWaived" Drop-Down value is Yes nothing additional needs to be added.

 

I think that's it for the time being, and again any help would be GREATLY APPRECIATED!!

 

This topic has been closed for replies.

1 reply

mommab26Author
Participating Frequently
April 21, 2020

Thank you for the information, however this stuff is like a foreign language to me. I am able to do these types of calculations in Excel but Acrobat is on a whole different level! So far, my experience with Acrobat DC Pro has been creating fillable PDF's (pretty basic stuff) and some simple calculations. This particular calculation is out of my league and I'm currently clueless on how to make this work. So any help would be greatly appreciated.

 

Thank You

Have an AWESOME-TASTIC Day!!!
try67
Community Expert
Community Expert
April 21, 2020

If you're interested I could write these scripts for you, for a small fee. You can contact me privately via [try6767 at gmail.com] to discuss it further.