Form calculation problems

[#1]

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

[#2]

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

[#3]

Did you checked the fields calculation order?

[#4 · Accepted solution]

You need to check field calculation order:

[#5]

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

Cheers, Andrew