Addition with negative numbers in a form

New Here ,
Dec 20, 2017

Copy link to clipboard

Copied

Hello, I am trying to add a column of positive and negative numbers on an electronically created form as shown below:

For some reason, the "Above Totals" field is treating the negative as a positive number, resulting in a total of 3 instead of 1. Once I finish typing in the next row; however, the field correctly treats the negative as a negative number as it should be calculated:

There seems to be some type of delay with this calculation that does not get corrected  until the user manually enters an additional piece of data. Is there a reason why this calculation is not happening automatically? Thanks so much.

Adobe Community Professional
Correct answer by Thom Parker | Adobe Community Professional

Usually, when calculations seem delayed by an entry it is a calculation order issue.  One calculated field depending on another, but the first field is calculated after the second. Do you have calculations that depend on each other for this result?

TOPICS
Acrobat SDK and JavaScript

Views

194

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Addition with negative numbers in a form

New Here ,
Dec 20, 2017

Copy link to clipboard

Copied

Hello, I am trying to add a column of positive and negative numbers on an electronically created form as shown below:

For some reason, the "Above Totals" field is treating the negative as a positive number, resulting in a total of 3 instead of 1. Once I finish typing in the next row; however, the field correctly treats the negative as a negative number as it should be calculated:

There seems to be some type of delay with this calculation that does not get corrected  until the user manually enters an additional piece of data. Is there a reason why this calculation is not happening automatically? Thanks so much.

Adobe Community Professional
Correct answer by Thom Parker | Adobe Community Professional

Usually, when calculations seem delayed by an entry it is a calculation order issue.  One calculated field depending on another, but the first field is calculated after the second. Do you have calculations that depend on each other for this result?

TOPICS
Acrobat SDK and JavaScript

Views

195

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Dec 20, 2017 0
Adobe Community Professional ,
Dec 20, 2017

Copy link to clipboard

Copied

Usually, when calculations seem delayed by an entry it is a calculation order issue.  One calculated field depending on another, but the first field is calculated after the second. Do you have calculations that depend on each other for this result?

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Dec 20, 2017 0
Adobe Community Professional ,
Dec 20, 2017

Copy link to clipboard

Copied

To Set the calc order. Put the form in "Prepare Form" mode, then select "Calculation Order" from the menu displayed by clicking on the button shown below.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Dec 20, 2017 1
Adobe Community Professional ,
Dec 20, 2017

Copy link to clipboard

Copied

Check the calculation order of the form.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Dec 20, 2017 0