Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I desperately need to know how to get the MIN of a range a numbers with positive and negative values, where only the positive values will be taken into account.
Example for the range of numbers:
6
2
-1
-5
Usually, if I stated min(numbers) -5 would be the outcome, however, I want 2 to be the outcome. How can I realize this?
Try this:
Min({<Numbers={">0"}>}Numbers)
or
nummax(0,(min(-1 * numbers) * -1))
Super! Thanks a lot!