You'll need to right-click on the final calculated field and edit the table calculation to make sure it's computed properly. Any chance of sharing a packaged workbook?
Hi, just following up to see if we have adequately addressed your question. If so, could you please mark one of the responses as the correct answer? If not, please let us know how else we can help. Thanks!