Help

How To Rollup MIN(values) of "1" or Greater, Excluding "0"

Topic Labels: Formulas
917 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Dereck_Hoekstra
6 - Interface Innovator
6 - Interface Innovator

I’m trying to roll up the smallest value from Table A into Table B that’s at least “1” or greater with MIN(values) rollup formula. The problem right now is some is table A has values of “0”, and I don’t want to return that number. Example below:

TABLE A
record #: 4
record #: 2
record #: 15
record #: 21
record #: 0

My formula returns the smallest number in table A, which technically is “0”, but I don’t want that number, and I’m trying to figure out a formula to exclude any value of 0 or less.

0 Replies 0