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
Feb 17, 2021 01:55 PM
Hi would someone be able to help me create a formula to find the % difference of 2 numbers?
Thanks!
Feb 17, 2021 04:41 PM
Hi Brittany. You’ll have to think about what your denominator should be. Here’s an option for % difference.
ABS(({Sold} - {Listed}) / {Listed})
Here’s an option for % of Listed that was Sold.
{Sold} / {Listed}
Format your formula field as a %. Cheers!