Hello! I’ve been struggling with a formula and am hoping for some help.
I have an $Invoice field, a $Paid field, and I’d like to have a Difference field (i.e., show $0 if a client paid their invoice in full, or show the balance due if an invoice is short-paid. I would also like the difference field to be blank if there is nothing in the $Paid field… that’s where I’m struggling.
Any suggestions?