Mortgage Calculator generates proper total, but DB, Confirmations, and Notifications log some other smaller number for the total field than the correct “Total” number being shown while entering all the field data.
This is the calculator. If you enter data, you’ll see a Total. if you also enter an email address, you will see a submit button that allows you to get a confirmation screen with all the data, and an email that contains all the data… including the “Total” which is inconsistent with the correct one being shown during the data entry.
I saw a suggestion to use a number field instead of a Total field so that the data gets logged to the DB, which I did and copy/pasted the same formula. The number field generates an inconsistent number in the confirmation/notifications, where the Total field gives a “$0.00” result.