- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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-paid | Amount | |
|---|---|---|
| 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!
Views
Replies
Total Likes