Help

Sales % differences showing Infinity and how to remove?

Topic Labels: Formulas
1707 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Rosa_Rezansoff
4 - Data Explorer
4 - Data Explorer

Hello, I need with some a formula I’m trying to calculate,

I need the percent (%) difference between two values fields and would like to format it so that if the percentage comes back as infinity, that data would be removed from the record so I can view the summary percentage of that field in my dashboard block.

This is the formula Airtable told me to use to get the percentage difference:
{PURCHASE PRICE}/{LIST PRICE}*100

…which shows up like:
ie: Sale Price/List Price100 = List to Sell Data %
$575,000/$500,000
100 = 115%
$575,000/$0*100 = Infinity

…but then my dashboard block can’t show the avg % of the sale to list price.

Any help would be extremely appreciated!

3 Replies 3

Hi @Rosa_Rezansoff - if you use:

IF({List Price} = 0, BLANK(), {Purchase Price}/{List Price})

then you’ll get this:

Screenshot 2019-05-31 at 12.55.18.png

At the bottom of the formula column you get this (if you select Avg):

Screenshot 2019-05-31 at 12.56.02.png

Which I think is what you are after

JB

Of course, the calculations don’t work horizontally in the summary bar, i.e.:

1650/700 < > 182.5%

Rosa_Rezansoff
4 - Data Explorer
4 - Data Explorer

Thank you so much!! That worked!