Skip to main content
Paul@40
Paul@40
Known Participant
August 2, 2023
Question

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

  • August 2, 2023
  • 2 replies
  • 4813 views

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 🙂

    This topic has been closed for replies.

    2 replies

    try67
    Community Expert
    try67Community Expert
    Community Expert
    August 10, 2023

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

    Paul@40
    Paul@40Author
    Known Participant
    August 11, 2023

    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.

    Paul@40
    Paul@40Author
    Known Participant
    August 11, 2023

    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.


    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.

    Bernd Alheit
    Community Expert
    Bernd AlheitCommunity Expert
    Community Expert
    August 3, 2023

    Change the field calculation order.

    Paul@40
    Paul@40Author
    Known Participant
    August 10, 2023

    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.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices