Known Participant

Answered

Calculated field adds a negative number instead of subtracting it

Forum|Forum|5 years ago
December 8, 2020
7 replies
3465 views

I have a purchase order form that I created, with calculated fields to take the quantity times the price to get an extended amount. I then have a calculated subtotal field at the bottom that sums all of the extended quantities. For the subtotal field, I selected the "Value is the sum of the following fields".

However, if there is a credit line and I enter a negative number, it adds the amount instead of subtracts it. If I take the minus sign out, then it subtracts it.

I'm sure I'm missing something really simple here, but I'd appreciate it if someone could help me out. Do I need to do an If/Then statement? What would that look like?

Thanks.

Lisa

This topic has been closed for replies.

Correct answer Nesa Nurani

You have a problam with delay probably, so check field calculation order. While in prepare form click on "More" "Field calculation order" and check your fields order.

cataholic_1Author

Known Participant

Thanks Nesa!

That was the problem. Once I changed the calculation order, the calculations work.

Thom Parker

Community Expert

That was one of the first suggestions you received.

Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often

cataholic_1Author

Known Participant

Oh, I didn't even see that answer. Sorry about that.

cataholic_1Author

Known Participant

Here is a link to the form.

https://drive.google.com/drive/folders/1_SLw3Gg4ZEra5_Rtbe2jx4DOtvB6-iMx?usp=sharing

Nesa Nurani

Correct answer

Community Expert

You have a problam with delay probably, so check field calculation order. While in prepare form click on "More" "Field calculation order" and check your fields order.

cataholic_1Author

Known Participant

I enter a negative number under Unit Price, which adds it to the subtotal.

Then, if I take the minus sign out, it subtracts the amount from the subtotal.

I've also noticed that the total is not calculating correctly. The formula is adding the Subtotal + HST.

Bernd Alheit

Community Expert

Change the field calculation order.

cataholic_1Author

Known Participant

Sorry, I missed this answer altogether. This worked. Thank you very much!

try67

Community Expert

Adding a negative number and subtracting a positive number is the same thing...

cataholic_1Author

Known Participant

I'd like to show a negative number and have it subtract from the total.

A

Asim123

Inspiring

In math minus and minus will give plus, but if you using sum and enter minus it should substract.Is your field format as number? Where are you entering credit line?

cataholic_1Author

Known Participant

Field format is number with 2 decimal places.

Bernd Alheit

Community Expert

Where does your enter the negative number?

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded