These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Calculation Help

2011-04-07 04:27:54

dgchapman

Registered: Apr 7 2011

Posts: 1

Apologies for what is probably the most stupid post on here

I have a simple table with 3 columns where I want to display the percentage reduction in column 3

essentially it looks like

Column a | Column b | Column C
| |
£ Spent | Saving% | Potential saving

The simple calc should be (c = a-b)

I've tried working this out, but I am extremely new to A9

my rough table can be viewed here http://img690.imageshack.us/i/tableown.jpg/

Any help would be greatly appreciated,

My Product Information:
Acrobat Pro 9.0, Windows

2011-04-07 04:37:52

try67

Registered: Oct 30 2008

Posts: 2398

You can use the simplified notation script for the calculation of the C fields, provided your A and B fields do not contain special characters or spaces. Let's say your first A field is called Spent1 and your first B field is called Saving1, then you enter this in the first C field's calculation:

Spent1 - Saving1

- AcrobatUsers Community Expert - Contact me personally at try6767 [at] gmail [dot] com
Check out my custom-made scripts website: http://try67.blogspot.com