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
Résolu ! Accéder à la solution.
Just drop a Filter tool before your Summarize to filter out the "zero" records.
Thank you. I clearly missed this one! Thanks for your help.