Skip to main content

Help with finding the percentage difference of 2 number

  • February 17, 2021
  • 1 reply
  • 10 views
B
Forum|alt.badge.img+1

Hi would someone be able to help me create a formula to find the % difference of 2 numbers?

Thanks!

1 reply

A
Forum|alt.badge.img+18
  • augmented
  • Inspiring
  • February 18, 2021

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!

Terms & ConditionsAccessibility statement