Re: Find the Difference Between two Columns

658 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I have two columns in dollar amounts, one is called “Total” and the other is called “Amount Paid.”

Basically, I need help with basic a subtraction formula to find what is the difference and that difference will go into a third column called “Available Balance.”

How do I accomplish this?

Thank you in advance!

1 Reply 1
7 - App Architect
7 - App Architect

Use the following formula for Available Balance
Total - {Amount Paid}

format the Field Available Balance properly.