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.
