Best Of

@ahw47 It's possible one or both of your columns are storing the numbers as text. Wrap the column references in the VALUE() function to ensure you are operating on numbers vs text.

This especially is plausible if you are importing the data from another system or copy and pasting it in.

 =value([Amount Invoiced]@row) - value([Amount Paid]@row)