Calculation not Working but is working. Strange issue - please read and assist!!

[Paul@40]

So I have created a document that calculates a 4 items. It was working perfectly until I added a 3rd and 4th row to allow the client to add in any miscellaneous fees.

Now the second item in the Invoice Details called Support calcuilates correctly in the Notes section but displays as £0.00 until you add any amount into the 3rd row. Then it appears.

I have no ideas why this is happening and I cant seem to effect it no matter what I try. The only thing that works is to remove it but that isnt really a working solution.

I have attache dthe document and filled out the calculation so anyone kind enough to take a look can see what is going wrong.

After it appears using the methos aboive the problem doesn't return. Its very perplexing.

Appreciate any assistnace with this. Thanks 🙂

[Bernd Alheit]

Change the field calculation order.

[Paul@40]

Thanks but already tried that and it didnt work. I 'fixed' it by entering 0.00 in the 2 blank total fields and saved the form with them 'hard' coded and that made everything work. 

It wasnt really a fix as the problem is still there if those fields are cleared but client was okay with that.

I guess its a too difficult fix as no one has come up with a solution to the original issue.

[try67]

There are errors in the validation script of CoreFeeDue. Remove that code, and then re-apply the calculation script of DailySupportFee.

[try67]

There's also an issue with the days fields showing -1 when the form is cleared, but that's unrelated.

[Paul@40]

Thank you. I did that but unfortunately it still wouldn't show the Total in SupportFeeDue until a value was added into the Item3Due field.

[try67]

Works fine for me...

See attached.

[Paul@40]

Hi... well I'm not sure what you are seeing at your end but here I am still seeing the same issue. Please see image attached. It should show the calculation total being £880.40 but it still shows £0.00 unless you add a value into the next total below.

[try67]

This image doesn't make sense. How can the Days value show 31 if there are no dates entered? Did you enter them and then delete them? If so, there's an issue with how you calculate the days, and/or with the fields calculation order.

[Paul@40]

Thats because it only calculates the days as its a monthly invoice and never exceeeds 1 month or 31 days. The calculations are only in the Days fields in ordfer to produce the muliplier for the Total Fees

The MM and YYYY fields play no part other than to advise the client. 

The only thing that doesnt work as expected is where I indicated with the red circle.

Hope that makes sense 🙂

[try67]

All of these things are interconnected. You still didn't say how you arrived to the state you showed in the screenshot, or what application you were using. Post a FULL-WINDOW screenshot.

[Paul@40]

I'm just using Adobe Acrobat. And the MM YYYY plays no part as they are just text fields. They do not contribute to the calculations?

The first DD provides the figure to multiply the Daily Core Fee by and the second DD provides the figure to multiply the Daily Support Fee.

As indicated the calculation works just fine. There isnt any issue with that in so much as it calculates correctly. The problem is with it not showing until a value is entered into Item 3 Due.

Before I added the Item3 and Item4 fields and their corresponding totals fields the problem did not exist.

So it doesnt matter if the MM and YYY are filled in or not. The caluclation still works.

I have attached a screenshot of the application but the problem persists in the browser of the full program. 

[try67]

Your image shows the total showing up, despite there no being anything in row 3... So I'm not really following.

However, like I said, the fields calculation order needs to be adjusted. DailySupportFee should appear before SupportFeeDue in the list.

[Paul@40]

The total i highlihghted in red is £0.00. Thats is what is incorrect. The Total is 14.29 x 31 which doesnt equal 0.00.

If you add a total in Item 3 (just below the field I highlighted in red) with any amount (even £0.00) and enter that you will then see that the Support Fee Total appears.

When i refer to total i refer to the column that has the totals in. I am not referring to the Grand Total. Each row has a Total. Row 2 Total doesn't show unless you enter a Total in row 3.

[try67]

It has nothing to do with row 3. It will happen the same if you change the address field, and the reason is the fields calculation order, as was mentioned already multiple times. I fixed it for you in the attached file, but I would strongly recommend you learn how to do it yourself, in case you need to create more forms in Acrobat.