Link to home
Start Free TrialLog in
Avatar of IO_Dork
IO_DorkFlag for United States of America

asked on

Excluding Zeros in Min function

I have a formula field that contains numbers and zeros and groupings.  If I have 0,25,50,100 as data points, I want to be able to use a min function to pull the minimum number excluding Zero for each group...so in this case it would pull 25 as the min. for group 1.  I tried using running total but that still pulls zeros or ""

What is the cleanest and most direct way to accomplish this, other than eliminating zeros via record selection?...i need all records returned to the report b/c I need to perform different calculations on the same data.

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of IO_Dork

ASKER

works for me. Thanks!