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 Price*100 = 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!