🧪 12 Formulas to get you started with the new Advanced Editor

[Richard_Sather]

Hi @Darren_Tuck , welcome to the forum

Thank you for your nice comment.
I’m not sure that a formula field is what you need in this case. I think you could create your tasks as per below, while using a simple number field for your units:

Task name	Units (number field)
Task 1	10,000
Task 2	-300
Task 3	-400
SUM	9,300

If you use positive and negative numbers you could get your tally from the SUM function at the bottom of your list. And you could also create charts in your project’s Dashboard.

Here is a useful guide that you could also refer to:

Quick Tip: Accounting in Asana

Track billing and payments easily in Asana with a numeric dollar amount custom field (requires any paid plan). You can also use this for loans and repayments. Use a positive number for the amount billed, a negative number for each payment, and see the current balance automatically at the foot of each section. See Customer 1 - Project 1 below for a simple example. Recurring (weekly, monthly) payments are a breeze by setting the Due date to repeat; marking complete will add the next recurrence be…

Let me know if I missed something!