Link to home
Start Free TrialLog in
Avatar of mcginniskj
mcginniskj

asked on

How do I add formula to attached Adobe Acrobat document?

I would like to know if it is possible to add a formula to the attached file.
I want to be able to type in the actual load measured in the actual load column and the load variation % would be calculated. Please help.

Thanks in advance.
KM
1360---1361-JAR-TESTER-CALIBRATI.pdf
Avatar of captain
captain
Flag of United Kingdom of Great Britain and Northern Ireland image

Hi

I am not a java script developer, but as this is a division you need JS to avoid dividing by zero. Have a look at this:
http://forums.adobe.com/thread/825757?decorator=print&displayFullThread=true

I assume that you want to divide the actual load by the console pressure or the difference of the actual load and console pressure by the console pressure. Either way you need to tell Acrobat about the console pressure so it can be used for calculation. For that you should put all console pressure variables into fields and make these 'Read only'. That way they cannot be edited but you can reference these for your calculation. At the moment Acrobat has these only as background text which you cannot use in a calculation.

Once you have got your formula right you then need to change the format to 'Percentage' and you should be done.

I would also recommend simplifying your field names as they are complex and you may end up with errors because of typos when you change your script. If you need to calculate the difference between console pressure  and actual load and then use the result as a dividend then you may find it easier using a field to calculate that difference first (fieldname1-fieldname2, for examle console1-actual1) and set the attribute to 'Hidden' so it is not visible but can be used for calculation.

The difference calculation formula goes into the simple annotation option.

hth
capt.
Avatar of mcginniskj
mcginniskj

ASKER

I need the difference of the console pressure and actual load divided by the actual load and this would give the load variance %. Do I need to add another column to show the load variance?
ASKER CERTIFIED SOLUTION
Avatar of captain
captain
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you