|
|
| Author |
Message |
shortbusdesigns
 Total Messages 9
|
| Subject: | Need some help... totals section won't work |
Hi... I am fairly new to working in livecycle and think i did pretty well to this point... buuut, I'm stuck.
Everything works for me on this except the final 4 sections of the table. (Subtotal, Tax, Total, & Deposit)
Can anyone help me here? I'd really appreciate it.
Lee
| Posted: 20 Oct 2009 04:31 AM |
|
|
| |
gkaiseril
 Total Messages 3000
|
| Subject: | Need some help... totals section won't work |
Do you receive any error messages?
I receive a number of 'Acessor' errors, which indicates an error in identifying the field.
Also the parameters passed in the 'Sum' function are separated by a ',' and not the '+' operator.
You may want to rename last couple of fields to agree with your calculation script and not the descriptive text of the field.
Posted: 20 Oct 2009 06:03 AM
Originally Posted: 20 Oct 2009 06:01 AM |
|
|
| |
shortbusdesigns
Total Messages 9
|
| Subject: | Need some help... totals section won't work |
Oops.. I didn't attach the right file. I had caught all of that. I'm still getting those errors, but I'm not sure what they mean. I've given each cell it's own name, but it just doesn't make sense to me that it doesn't work if the top section does.
Thanks for the help, I need it! lol
Lee
| Posted: 20 Oct 2009 06:58 AM |
|
|
| |
gkaiseril
Total Messages 3000
|
| Subject: | Need some help... totals section won't work |
You are still obtaining the 'Accessor' or object reference errors.
The FormCalc script for the Deposit field needs to read:
Row12[3].cell4o * 0.5
You need to specify more than the cell name since you are in a table, you need to at least specify the row and iteration of the row when needed.
| Posted: 20 Oct 2009 07:24 AM |
|
|
| |
shortbusdesigns
Total Messages 9
|
| Subject: | Need some help... totals section won't work |
ARRRGH... ok. I just don't get the logic here. What you gave me works, but when I change everything else to match - nada. This is really starting to bug me. What am I missing?
| Posted: 20 Oct 2009 11:55 PM |
|
|
| |
BAlheit
 Total Messages 854
|
| Subject: | Need some help... totals section won't work |
Look at the error messages when you open the form in Adobe Acrobat.
| Posted: 21 Oct 2009 01:39 AM |
|
|
| |
shortbusdesigns
Total Messages 9
|
| Subject: | Need some help... totals section won't work |
The error messages are greek to someone that doesn't understand this past it's relation to excel sheets and the formulas used there. I have done this in a way that SEEMED logical, but it doesn't work. I always get the same error messages.
| Posted: 21 Oct 2009 03:13 AM |
|
|
| |
BAlheit
Total Messages 854
|
| Subject: | Need some help... totals section won't work |
Don't you see the first error: row1.cell4a is unknown ?
There is no row1 in your form.
| Posted: 21 Oct 2009 04:18 AM |
|
|
| |
gkaiseril
Total Messages 3000
|
| Subject: | Need some help... totals section won't work |
You have to get the field names are references letter perfect, spelling and capitalization.
Your total field script needs to be:
// original
// row1.cell4a + Row2.cell4b + Row3.cell4c + Row4.cell4d + Row5.cell4e + Row6.cell4f + Row7.cell4g + Row8.cell4h + Row9.cell4i + Row10.cell4j + Row11.cell4k + Row12[0].cell4l
// corrected
Row1.Cell4a + Row2.Cell4b + Row3.Cell4c + Row4.Cell4d + Row5.Cell4e + Row6.Cell4f + Row7.Cell4g + Row8.Cell4h + Row9.Cell4i + Row10.Cell4j + Row11.Cell4k + Row12[0].Cell4l
| Posted: 21 Oct 2009 05:12 AM |
|
|
| |
|
|
