Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Dec 03, 2021 12:46 PM
Hi,
I’m setting up a bookkeeping system for my business.
What I need is that when I select the option “Expense” from the Single Select option in the Type field, I want to add a negative sign with the Received Amount field so that it is subtracted from the sum.
I’m attaching a screenshot for clarity.
I’d really appreciate it if someone can help me with the formula for this.
Thanks a lot :slightly_smiling_face:
Dec 03, 2021 01:02 PM
Hi Ghazi. Try this…
IF({Type}='Expense', -1*{Total}, {Total})
Good luck.