Sharepoint - How do I minus the total sum amount from the available balance?

Question

Hello,

I am a SharePoint Newbie. I've created an expense tracker with a Total Sum tally. But I want to have another Total that will be the sum of the expenses minus the total amount available for that month or quarter. Is there a way to do that? When the report is viewed I want to see what's left in the bucket, then have the breakdown of what we purchased what was purchased.

Answer 1

Per my research, there is no OOTB way to real-time calculate the total which refers to the sum of the expenses minus the total amount available for month or quarter.

As a workaround, you could Export the list to excel, then use calculate function in the excel.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.