|
| | |
Forum Newbie
Group: Forum Members
Last Login: 12/19/2007 2:03:30 PM
Posts: 3, Visits: 8 |
| | I am trying to do a calculation in a custom form using Point Field 630 I just want the form to display the amount of field 630 * 12 to get the annual adjusted Gross Income I am trying {= <<pnt_630>>*12} It displays a sytax error in print preview mode And if I try to print a PDF, I get a PDF that Says "There was a field calculation error in field 1" Anyone now exactly how to accomplish this?
Steve B |
|
|
| | |
Supreme Being
Group: Forum Members
Last Login: 12/16/2008 1:31:52 PM
Posts: 124, Visits: 970 |
| | the formula should read {={MERGEFIELD PNT_630}*12} you may need to hit ALT+F9 to see the actual formula.
"MMM Yeah, I'm going to need you to go ahead and come in on Saturday." |
|
|
| | |
Forum Newbie
Group: Forum Members
Last Login: 12/19/2007 2:03:30 PM
Posts: 3, Visits: 8 |
| | I tried it... Now I am getting the following error in Print Preview Mode !Syntax Error, { When I actually print the form I get the message A field Calculation error occurred in record 1
Steve B |
|
|
| | |
Supreme Being
Group: Forum Members
Last Login: 12/16/2008 1:31:52 PM
Posts: 124, Visits: 970 |
| are you doing any other calculations in the form?
"MMM Yeah, I'm going to need you to go ahead and come in on Saturday." |
|
|
| | |
Junior Member
Group: Forum Members
Last Login: 5/8/2008 10:41:52 AM
Posts: 17, Visits: 91 |
| I've found that the only time I get a field calculation error is when the field is empty; it won't treat it as zero. (Though if anyone knows a slick way around this, please post!) **Never mind, I found your other thread, JohnP.  FWIW Steveb16, I tried your formula and it worked fine for me.  |
|
|
| | |
Forum Newbie
Group: Forum Members
Last Login: 12/19/2007 2:03:30 PM
Posts: 3, Visits: 8 |
| | John, This is the first calculation in the form. I do have several others once I get this issue worked out. I do have income in the test 1003 so pnt_630 does have a value. I am using word 2003 and Point 6.0a. I'd be happy to send you my custom form in an attachment if you had time to take a look at it. I appreciate your help so far.
Steve B |
|
|
| | |
Supreme Being
Group: Forum Members
Last Login: 12/16/2008 1:31:52 PM
Posts: 124, Visits: 970 |
| | it may not be this first calculation that is causing the error. It can be a problem with one of the other calculations you are doing. I emailed you, you can send me the doc and I will be happy to look at it. Make sure you save it as a .doc or .txt before you email it, or you can post it here.
"MMM Yeah, I'm going to need you to go ahead and come in on Saturday." |
|
|
| | |
Forum Member
Group: Forum Members
Last Login: 12/21/2008 6:55:00 PM
Posts: 30, Visits: 79 |
| | John and Steve, I'm sure I can speak for others that we would love to see the solution. If Steve's custom form is confidential maybe John could just post a coulple of the lines of calculations so the rest of us could check it out. Thanks! Mike Mullin |
|
|
| | |
Supreme Being
Group: Forum Members
Last Login: 12/16/2008 1:31:52 PM
Posts: 124, Visits: 970 |
| most of the formulas that I use are simply modified If.. Then Statements that I insert Point Mergefields into. The key to making these work is making sure that you understand the argument that you are putting into place.
"MMM Yeah, I'm going to need you to go ahead and come in on Saturday." |
|
|
| | |
|