I have a column 1 called players fees (example $1,000)
A column 2 called order revenue (example A $2,000; Example B $500)

I want a 3rd column where IF the sum of player fees (column 1) - order revenue (2) is + the 3rd column equals zero. (example $1,000 - $500 = $1,500 but the row would show $0)
IF the sum of player fees (column 1) - order revenue (2) is - the 3rd column equals the negative number (example $1,000 - $2,000 = -$1,000)

my current formula is: IF (column 1-column 2 = > 0, 0, column 1-column 2)
But itâs still returning the positive numbers.

To explain the purpose here, I want to track how much money I OWE out to players who are owed money (the negative numbers), but not what I am still owed (the positive numbers).

Itâs much easier for me and others to help you if you share your doc with us. We can take a look into the formulas and everyone can make a copy of the document so we donât get in the way of each other.

Please follow this guide to share your doc with us:

Hey @Ruby_George1 ,
Screenprints donât really help here. What @Jannis means is for you not to share a doc with private data, but to make a small representative dummy doc that resembles the doc where you have a problem. The screenprints show columns that we donât see, so how would you expect to get a proper answer.
If you donât want to take the time to share a doc with the community, I think the people that can really help you are not going to take the time to give you some guidance.

First of all, thank you for sharing your document. This helps a lot!

Unfortunately, I couldnât fully understand what youâre trying to achieve.
Can you please describe it in more detail using the column names you use in your document? Please also define your desired output for better understanding.

Iâm looking to update the formula in âDue to Playersâ

What I want to know is the sum of money I owe to players. If the number is negative in Due to Players, that means I owe them money.
If the number is positive in âDue to playersâ that means they still owe me money so I want to filter the positive numbers out.

Basically Iâm just trying to put money in reserve for what I owe out and want to know ONLY what I owe out to players.

I feel like I understand formulas pretty well but every time I want to do something new like this in Coda I have ask because what I think should work, doesnât! I appreciate all of your help very much.

I just reread your posts and the comments in your doc.
You wanted to show only the negative Numbers in the Column âDue to playersâ.
After I checked the doc, I noticed that this is already happening.

thanks so much for helping! Someone made a comment in the document itself that they fixed the formulaâŚ this is the formula now for anybody who is looking:
Withname(
thisRow.[Player Fees]-thisRow.[Orders Revenue],Amount,
If(Amount<0,Amount,ââ)
)