Highlighted

Form calculation problems

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

You need to check field calculation order:

Izrezak.PNG

TOPICS
Create PDFs, PDF forms

Views

54

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

Form calculation problems

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

You need to check field calculation order:

Izrezak.PNG

TOPICS
Create PDFs, PDF forms

Views

55

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
Oct 05, 2020 0
Adobe Community Professional ,
Oct 05, 2020

Copy link to clipboard

Copied

Did you checked the fields calculation order?

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...
Oct 05, 2020 0
Engaged ,
Oct 05, 2020

Copy link to clipboard

Copied

You need to check field calculation order:

Izrezak.PNG

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...
Oct 05, 2020 1
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

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...
Oct 07, 2020 0