New "parts" for has 7 columns across: Part number, description, unit price, quantity, extended price, discount %, line total. I can't find a way to get the calculation for the line total correct. If I multiply the entend price x discount = the discounted value (example price of $100; 10% discount, results in the line total of $10 instead of $90). Everyother item on the form works except this one. Thanks!
Jennifer Umbright 931 days ago
How are the fields set up? Do they have formatting? How are you executing the calculation?Are there any error messages in the console?
Using Adobe Acrobat. I have formatted each text box as a number,and giving each a unique name. I am just to green with this....not sure what info. to supply.
Jennifer Umbright Commented 931 days ago | Report
If it works with other fields, there must be an issue with one of the settings. Also, try re-applying the calculation script. It can sometimes get corrupted, for example when you change the name of one of the fields involved.
Gilad D (try67) Commented 931 days ago | Report
The other fields are "products" - I need to subtract the discount from the extended price. My only choices are "sum, product,average, minimum and maximum. I don't know how to get difference between two fields.
I see what's the issue now. If you define the discount field as a percentage field its value will be between 0 and 1, and then you can use the "product" operator to calculate the discounted price. But more generally, to use subtraction you can use the second option in the Calculate tab, the Simple Field Notation, where you can simply enter the names of the fields and the mathematical operators you want to use (the field names may not contain spaces, comma's or other special characters, though).
Gilad - you solved it! I was not setting the percentage value range - thank you so much for your help! Awesome.
Glad to hear it. Please mark the question as answered.
If you insist on using the no brain options, you can create extra fields to change the subtrahend value to its negative value (multiply by -1) and then add the negative value.
I tried adding an extra field to hid the discounted value - not sure how to add change to the negative. I am using Adobe for calculations for the first time - so no brains is where I am right now.
You can make a field with an optional value of -1 and then use that field to compute the negative of the discount amount.
George Kaiser Commented 931 days ago | Report
Thanks - Gilad was able to solve issue - I was missing assigning the value of 0-1 for the percentage. I will make a note of this for next time. I appreciate your feedback!
Acrobat XI trial
Get the trial now
I am trying to save a pdf file from email to my personal computer, but I am told I need ad...
Asked by ramin zargari · no replies
when a user of reader, version 11.0.07, uses a standard stamp on a shared review document,...
Asked by Ruth Primett · 1 answer
I have successfully designed a form in live cycle - Need help with Acrobat
Asked by meisen321 · 1 answer
Asked by Matt Wunsch · 4 answers
Adding date/time to multiple pdf pages when printing.
Asked by Damell Horton · 1 answer
Is it possible to add a headline to a pdf document after electronic signature?
Asked by PETRA DUCHRAU · 1 answer
Last 30 Days
The Acrobat User Community is where you can connect with Acrobat and Adobe Document Services peers and experts. If you use Acrobat, Reader, FormsCentral or EchoSign, you'll want to take advantage of the many free community resources like tutorials, tips, and Q&A to learn more about Acrobat and document services.