Hi would someone be able to help me create a formula to find the % difference of 2 numbers?
Thanks!
Hi would someone be able to help me create a formula to find the % difference of 2 numbers?
Thanks!
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.