Adobe Acrobat PRO messes up calculations to 100%

[smileBeda]

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.

[try67]

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.

[smileBeda]

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]

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).

[bebarth]

Hi,

You could use 2 custom scripts for the percentage field that would allow to type 10 instead of .1 for 10%.

@+

[smileBeda]

Thank you for your effort, really.

But you can imagine that - even while I am a programmer who understands JS and PHP - I have no intention whatsoever to write code into a 100-usd product just because it does act buggy.

Nevermind, I just used plain text, invalidated and unformatted, and it works like a charm now.
Not sure what the whole hipe is on their doc that for calcualations we HAVE to use validated and formatted fields. It is clearly not true.

Now I have a fully working hours x fee + (the total/100*VAT) calculation setup with simple text fields, the only "caveat" is that it shows like 1234,99 - but that is just fine, because the weird 1,234.99 syntax is "wrong" anyway in many parts of the world. Most use comma as the separator to decimals, and no separator for the thuosands.

So I am happy with that 

Thanks again for your clear and unexected effort of giving an example with code! 🙂

[Mehroosha26259377uvxd]

i am facing the same issue in putting digits . 

[Spam link removed]

[Gigabot]

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]

You don't need to convert it back. If you multiply the value of the field you'll get the correct result.

However, it is possible to do what you asked for. Change the field's Format to Custom and use the following code as the Format script:

if (event.value) event.value+="%";

However, be aware this will allow the user to enter non-numeric values into the field.

If you want to prevent that use the following as the custom Validation script:

event.rc = !isNaN(Number(event.value));

[Gigabot]

Thanks for the quick response-  maybe I don't follow - When I set to percent. Then go back to my form...I type in 10 it changes the field to 1000% (that doesn't make sense) It is a percent field, surely people want to put in a percent? I type 10% it should divide by 100 and give me a field value of .10 so that can be multiple by the subtotal? If it retains the value of 10 the next calculation will multiple 10 by the subtotal giving also the wrong answer.   Subtotal 100 - I want 10% off - Total - $90.  

[Gigabot]

I have to do this. -   (TaxPercent/100)*(SubTotal-TotalDiscount)    But why is the discount and tax field showing the percent x 100? I just want it to show what is typed in. 

[Gigabot]

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 %

[try67]

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