Skip to main content

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.

Be the first to reply!

Reply