Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Highlighted

Explorer
,

Oct 05, 2020

Copy link to clipboard

Copied

Hi there,

Any help for this will be greatly appreciated.

I have to set up a PDF based invoice where calculations have to happen within the form. I set one up the other day for a client and it worked fine. Now they've asked me to set up another one with different calculations and it's not behaving as expected.

Basically, there is a Total Hours column multiplied by an Hourly Rate column which calculates in a Total Cost column. The calculation I have is: formhours[number]*formhourlyrate[number] running down each of the 20 rows of the total cost column. This yields a correct sum in the corresponding row within the Total Cost column. However while the calculation in the Totals down the bottom yields a total for Total Hours, it does not yield a total for Total Cost although the calculation methods are the same.

Then moving across the form there is a Client Contribution column that needs to be subtracted from the Total Cost column to give a figure in the final Balance Due column. This calculation is :formservicecost[number]-formcontribution[number]. Only when a figure (even 0) is put in the Client Contribution column, does the previous Total Cost column yield a total at the bottom.

The Balance Due Total at the bottom uses the same calculation method as Total Hours but always seems a calculation behind in yielding a total. However the final Balance Outstanding figure (which I guess is the most important figure) updates correctly with every entry.

I've attached the PDF in its basic form and I'm hoping someone can let me know where I'm going wrong in the calculations so that all fields calculate immediately.

Thank you in advance.

Andrew

Engaged

You need to check field calculation order:

TOPICS

Create PDFs,
PDF forms

Community Guidelines

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

Explorer
,

Oct 05, 2020

Copy link to clipboard

Copied

Hi there,

Any help for this will be greatly appreciated.

I have to set up a PDF based invoice where calculations have to happen within the form. I set one up the other day for a client and it worked fine. Now they've asked me to set up another one with different calculations and it's not behaving as expected.

Basically, there is a Total Hours column multiplied by an Hourly Rate column which calculates in a Total Cost column. The calculation I have is: formhours[number]*formhourlyrate[number] running down each of the 20 rows of the total cost column. This yields a correct sum in the corresponding row within the Total Cost column. However while the calculation in the Totals down the bottom yields a total for Total Hours, it does not yield a total for Total Cost although the calculation methods are the same.

Then moving across the form there is a Client Contribution column that needs to be subtracted from the Total Cost column to give a figure in the final Balance Due column. This calculation is :formservicecost[number]-formcontribution[number]. Only when a figure (even 0) is put in the Client Contribution column, does the previous Total Cost column yield a total at the bottom.

The Balance Due Total at the bottom uses the same calculation method as Total Hours but always seems a calculation behind in yielding a total. However the final Balance Outstanding figure (which I guess is the most important figure) updates correctly with every entry.

I've attached the PDF in its basic form and I'm hoping someone can let me know where I'm going wrong in the calculations so that all fields calculate immediately.

Thank you in advance.

Andrew

Engaged

You need to check field calculation order:

TOPICS

Create PDFs,
PDF forms

Community Guidelines

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

designer-images

Oct 05, 2020
0
/t5/acrobat/form-calculation-problems/td-p/11483478
3
Replies
3

Adobe Community Professional
,

Oct 05, 2020

Copy link to clipboard

Copied

Did you checked the fields calculation order?

Community Guidelines

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

Reply

Loading...

ls_rbls

Oct 05, 2020
0
/t5/acrobat/form-calculation-problems/m-p/11483500#M279997
Engaged
,

Oct 05, 2020

Copy link to clipboard

Copied

You need to check field calculation order:

Community Guidelines

Reply

Loading...

Nesa Nurani

Oct 05, 2020
1
/t5/acrobat/form-calculation-problems/m-p/11483515#M279998
designer-images
LATEST

Explorer
,

Oct 07, 2020

Copy link to clipboard

Copied

Thank you! I managed to get everything working correctly. Thank you both so much for your help.

Cheers, Andrew

Community Guidelines

Reply

Loading...

designer-images

Oct 07, 2020
0
/t5/acrobat/form-calculation-problems/m-p/11488732#M280382
Resources

About Adobe Acrobat

Adobe Inc

Adobe Inc

Adobe Inc

Adobe Acrobat Feature & Workflow

FAQs

Using the Community
Experience League
Terms of Use
Privacy Policy
Cookie preferences
AdChoices
Language:

- Deutsch
- English
- Español
- Français
- 日本語コミュニティ
- Português

Copyright © 2020 Adobe. All rights reserved.