Summarize Tool - MIN function to Exclude Zero

[aesham]

Hello,

i have a Price field that I use to compute the market-level average price, max price, min price, modal price and median price.

If an earlier scrub program determined that the price of the item was"illegal" based on a price range table, the price is zero'd out.

So if there are any zero'd prices in a market, the MIN will generate as '0'.

Any ideas on how I can get the lowest non-zero price in the market for my MIN.

The Average, Mode, and Median functions allow  zeros to be excluded.

Thank you for your help.

Andrew

[RodL · Accepted solution]

Just drop a Filter tool before your Summarize to filter out the "zero" records.

[aesham]

Thank you.  I clearly missed this one!  Thanks for your help.