Skip to main content
N
NicoleHickman
Participating Frequently
November 10, 2019
Answered

Acrobat Forms - Calculations

  • November 10, 2019
  • 1 reply
  • 3530 views

So I've created an Acrobat form, and I want to use the calculate feature for some of the fields, to enter the results into another field. And that's working great. But I also then want to calculate the total from that field plus another field, with results to end up in a third field. And I can't seem to get it to work. 

 

Is it because one of the fields used in the calculation gets its total from other fields as opposed to direct input? 

    This topic has been closed for replies.
    Correct answer try67

    Really? From my file, or did you create your own? So you were able to get "Total Fee Write-Off Amount" and "Total OOP Write-Off Amount" to sum into "Total Write-Off Amount" (the third field in the gray bar)? Using the same settings as mine? 


    Yes, in my own file. I had a chance to examine your file more closely and I found the issue for this error.

    Somehow (my guess is you created the fields in InDesign, not Acrobat), you were able to insert a space at the end of the field name of "Total OOP Write-Off Amount", which causes it not to be picked up by any scripts.

    Remove that space and it should work correctly.

    1 reply

    try67
    Community Expert
    try67Community Expert
    Community Expert
    November 10, 2019

    No, that should not be an issue. The only thing you have to make sure is that the calculation order is correct, ie that the total field is calculated after the fields it uses for its own calculation.

    Please specify in what exact way it's not working and we'll help you further with this issue.

    N
    NicoleHickmanAuthor
    Participating Frequently
    November 10, 2019

    The first total field is working correctly, that is, grabbing the sum of figures entered into the input fields. That total field is then followed by another field, which the user needs to enter an amount into manually, and then the third total field should sum the values from the first and second fields. I Googled calculation order, but could not find where to adjust the calculation order in my version of Acrobat, which is Pro DC, latest version. 

     

    That third field is not resulting in a total of the prior two. It just remains at zero.

     

    So I have essentially four types of fields. The results of the first group, up to seven different fields titled "Write-off amount", should sum together and the total lands in a field titled "Total Fee Write-Off Amount". This field is followed by a field titled "Total OOP Write-off Amount", which the user enters a value into, and then the final field should sum the totals from "Total Fee Write-Off Amount" and "Total OOP Write-off Amount". 

    try67
    Community Expert
    try67Community Expert
    Community Expert
    November 11, 2019

    The field calculation order can be set via Prepare Form - More - Set Fields Calculation Order.

     

    I would recommend you check the JS Console (Ctrl+J) for error messages.

     

    Also, if you could share the file with us we could help you fix the issues in it.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices