Avatar

Level 2

Hi Bruce,

I am so sorry for being such a pain but let me show you how my table looks like and maybe it will help me explain what I am trying to accomplish here.


Pre-paidAmount
Air
Bus
Rail
Rent-A-Car
Parking
Gas
Shuttle
Taxi
Personal Car
Registration Fee
Hotel
Internet Fee
Meals
Tolls
Phone Calls
Per Diem
Misc
Total Expenses Incurred
Pre-paid Expenses
Amount due to Claimant

The  "Pre-paid" column is a drop-down with options of Yes, No, and N/A in which I renamed each cell to "PrePaid".   What I would like to do is to sum-up the amount on the "Amount" column  (which all the cells I have renamed to "Amount") relative to the "Yes" on the "Pre-paid" column on the "Pre-paid Expenses" box.

Just a note again, all cells below the "Pre-paid" column, I renamed "PrePaid".  All the cells below the "Amount" column, I renamed "Amount".  Was I supposed to do that? Are all the cells supposed to be JavaScript.  "Total Expenses Incurred" is FormCalc since I just added all the way down.  "Amount due to Claimant" is FormCalc as well since it is just the difference of "Total Expenses Incurred" and "Pre-paid Expenses".

http://forums.adobe.com/thread/426018 I found this thread and it is very similar to what I am trying to accomplish, however when I plugged in the code, it did not work; I believe because I already have a pre-made table, whereas for that particular instance, you have an option of adding a row.

I really appreciate your help and again, thank you!