Help

Help with finding the percentage difference of 2 number

Topic Labels: Formulas
1342 1
cancel
Showing results for 
Search instead for 
Did you mean: 
brittany_Barnes
4 - Data Explorer
4 - Data Explorer

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

image

Thanks!

1 Reply 1
augmented
10 - Mercury
10 - Mercury

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!