I volunteer at a nonprofit free medical clinic. We want to create a fillable Intake Screening form to qualify the uninsured patients that we serve. I am using Acrobat pro 7.0
I am having trouble with the budget computation part of the form. I would appreciate help with getting the calculations to work.
Budget Computation
Line 1. *TotalBaseIncome*
Line 2. *TotalEmployedMembers* (Minus)
Line 2A.*TotalFamilyIncome* (Total)
Line 3. *ChildCarePaid* (Minus)
Line 3A.*TotalGrossIncome* (Total)
Line 4. *TotalChildSupportReceived* (Minus)
Line 5. *TotalNetIncome* (Total)
All calculations are done in Simplified Field Notation.
Line 1. Not calculated (amount copied and entered from another part of the form)
Line 2. Not calculated (not always required to be entered)
Line 2A. *TotalBaseIncome*-*TotalEmployedMembers*=*TotalFamilyIncome* (this line displays $1.00 anytime the form is opened up in Adobe Reader before any amount is entered)
Line 3. Not calculated (not always required to be entered)
Line 3A. *TotalFamilyIncome*-*ChildCarePaid*=*TotalGrossIncome*
Line 4. Not calculated (not always required to be entered)
Line 5 *TotalGrossIncome*-*TotalChildSupportReceived*=*TotalNetIncome*
None of these lines will calculate when amounts are entered into them.
I have also tried the simple calculation as Field1-Field2 for each line without the =Field at the end.
All fields are formatted as a number, 2 decimal places with $
I have checked and verified that the form has the correct field calculation order
Form field calculations not working
2011-05-18 21:46:44
Answered
My Product Information:
Acrobat Pro 7.0, Windows
Acrobat Pro 7.0, Windows
2011-05-19 03:35:13
#2
George thank you for your reply.
I have tried the format you suggested before and it did not calculate the amounts. The field name format I used was *FieldName* throughout the form.
Where can I attach the form so that you could see it?
I have tried the format you suggested before and it did not calculate the amounts. The field name format I used was *FieldName* throughout the form.
Where can I attach the form so that you could see it?
2011-05-22 16:07:11
#3
I am using Acrobat 9 Pro for Macintosh. I created a pdf out of InDesign. I'm trying to make it an interactive/fillable pdf.
Field X
Field Y
Field Z
Field Z would be the result of Field Y being divided by Field X.
All three fields are formatted as a number, decimal places “2,” no currency symbol. Field values are not validated. For Field [Z] in the calculation, I checked “Simplified Field Notation” and entered: Y / X
Field [Z] would be a result of division [Y divided by X]. It calculates correctly, but pop up messages keep appearing all over the document when you try to enter information in other fields that say: The value entered does not match the format of the field [Z]. And then it pops you back to the page with that field on it [Z].
HELP! How can I rectify this problem?
Field X
Field Y
Field Z
Field Z would be the result of Field Y being divided by Field X.
All three fields are formatted as a number, decimal places “2,” no currency symbol. Field values are not validated. For Field [Z] in the calculation, I checked “Simplified Field Notation” and entered: Y / X
Field [Z] would be a result of division [Y divided by X]. It calculates correctly, but pop up messages keep appearing all over the document when you try to enter information in other fields that say: The value entered does not match the format of the field [Z]. And then it pops you back to the page with that field on it [Z].
HELP! How can I rectify this problem?
2011-05-22 16:17:49
#4
Does the calculation work when you enter values?
What happens when you place zero in the 'X' field?
What is the expected value for that calculation when you do it by hand?
Search these forums for a similar problem and you will find the custom calculation script you will need to use after you have modified the script for your field names.
What happens when you place zero in the 'X' field?
What is the expected value for that calculation when you do it by hand?
Search these forums for a similar problem and you will find the custom calculation script you will need to use after you have modified the script for your field names.
2011-05-24 03:52:07
#5
When using simplified field notation, you should enter:TotalBaseIncome - TotalEmployedMembers
making sure that those are the exact field names, including capitalization. If that doesn't work, it would be helpful if you could post the form somewhere so we could take a look.
Removing the asterisks from the field names allowed the calculations to work! Thank you George! making sure that those are the exact field names, including capitalization. If that doesn't work, it would be helpful if you could post the form somewhere so we could take a look.
TotalBaseIncome - TotalEmployedMembers
making sure that those are the exact field names, including capitalization. If that doesn't work, it would be helpful if you could post the form somewhere so we could take a look.