How to automatically calculate the balance like excel？

Can JOTFORM automatically calculate income and expenses to get the balance? How should I set it up，

Unfortunately, it is not possible to calculate values in the submission table.

You may however calculate balance in excel by downloading the submission data.

Guide:https://www.jotform.com/help/73-how-to-download-form-submissions-as-excelcsvpdf

If you have further questions, let us know.