Skip to main content
Known Participant
September 23, 2022
Question

Adobe Acrobat PRO messes up calculations to 100%

  • September 23, 2022
  • 2 replies
  • 5604 views

I have a few input fields and an output field.

Calculation is totally broken.

 

1. It asks me to add valid numbers like 1,22 or 122 - if I do that, it still assumes the numbres totally wron

2. Worse, when I do calcuation (INPUT/100)*INPUT it throws out sometimes the rigth result and sometimes a wrong.

 

Just look at these screnshots and tell me how to NOT go and kill myself. Been this all day with the complexity of Adobe and now the calculation is not even right?!
All fields are properly setup and validated as per the documentation, i have also tried all possible other scnearios of validation, it plain simple does not work.

 

100% for example adds 100%. Good. So does 10% lol and 1%.

What the actual ffffff. I am losing it - as said been at this all day!

 

Adobe is up to date, mac pro too. I am editing this as a template, online, since Adobe does not even allow editing these locally.

 

This topic has been closed for replies.

2 replies

Participant
September 23, 2022

i am facing the same issue in putting digits . 

 

[Spam link removed]

Participating Frequently
October 18, 2023

This is kooky. I have a form where I want the client to put in the tax rate...Say 9.3. If I want to use the percent format I have to tell the client to type in .093 just so the field spits out 9.3% at which point I now have to convert it back to the decimal to do the next calculation. Am I wrong? How about...let me put it in as a number and let me pick % for the symbol but that is not an option. 

try67
Community Expert
Community Expert
October 18, 2023

I think I see now-  If I tell the client to type in the decimal it then spits back the correct % value - then in the next calculation I don't need /100.  I guess that is ok but people are dumb and just want to type in the discount %


Correct, on both accounts... Use the scripts I provided and it should work like you described.

try67
Community Expert
Community Expert
September 23, 2022

My guess is it's an issue with how you're treating percentages in your calculations. A field set to Percentage will have a value between 0 and 1, not 0 and 100. If you have a field with a value between 0 and 100 and want to use it as a percentage you need to divide that value by 100 first, before multiplying it by another value, or you will get results 100 times larger than what they should be.

You need to share the file for further help with this.

smileBedaAuthor
Known Participant
September 23, 2022

Yeah, I'm aware how to calculate percentage, and that field is a number field, not a percentage- and then calculated Formula is correct 

 

as shown in the screenshots

 

its solved by making all fields simple invalidated unformatted fields

 

so it's clearly an issue with how Adobe interpretes it's own fields.

 

im tired of this, so I just will keep unformsatted fields. Works and saves me the surprise of chargin 5000 dollar vat on a client 😑😑😑😑

 

try67
Community Expert
Community Expert
September 23, 2022

Again, without seeing the actual file it's impossible to help you with this issue. I can assure you that if set up correctly calculations in Acrobat will work just fine, with a few fringe exceptions (especially when it comes to fractions).