My goal is to subtract the gross from the bca total/balance. But the problem with my code, it doesn’t subtract properly. Just like what happen in the picture. The beginning balance is 1000, and if I input 500, the new balance should be 500. However, in my code, it is showing as -500.](https://i.stack.imgur.com/unLm1.png)](https://i.stack.imgur.com/unLm1.png)
This is my code
function addData() {
// Get input values
let dv = document.getElementById("dvInput").value;
let date = document.getElementById("dateInput").value;
let number = document.getElementById("numberInput").value;
let check = document.getElementById("checkInput").value;
let payee = document.getElementById("payeeInput").value;
let uacs = document.getElementById("uacsInput").value;
let particulars = document.getElementById("particularsInput").value;
let project = document.getElementById("projectInput").value;
let period = document.getElementById("periodInput").value;
let gross = parseFloat(document.getElementById("grossInput").value) || 0;
let bir = parseFloat(document.getElementById("birInput").value) || 0;
let net = parseFloat(document.getElementById("netInput").value) || 0;
let receipts = document.getElementById("receiptsInput").value;
let total = parseFloat(document.getElementById("totalInput").value) || 0;
// Subtract Gross from the previous BCA Total/Balance
let newBcaTotalBalance = total - gross;
// Get the table and insert a new row at the end
let table = document.getElementById("outputTable");
let newRow = table.insertRow(table.rows.length);
// Insert data into cells of the new row
newRow.insertCell(0).innerHTML = dv;
newRow.insertCell(1).innerHTML = date;
newRow.insertCell(2).innerHTML = number;
newRow.insertCell(3).innerHTML = check;
newRow.insertCell(4).innerHTML = payee;
newRow.insertCell(5).innerHTML = uacs;
newRow.insertCell(6).innerHTML = particulars;
newRow.insertCell(7).innerHTML = project;
newRow.insertCell(8).innerHTML = period;
newRow.insertCell(9).innerHTML = gross.toFixed(2);
newRow.insertCell(10).innerHTML = bir.toFixed(2);
newRow.insertCell(11).innerHTML = net.toFixed(2);
newRow.insertCell(12).innerHTML = receipts;
newRow.insertCell(13).innerHTML = newBcaTotalBalance.toFixed(2);
newRow.insertCell(14).innerHTML =
'<button onclick="editData(this)">Edit</button>' +
'<button onclick="deleteData(this)">Delete</button>';
// Clear input fields
clearInputs();
}