1 of 1 people found this helpful
You can combine an IF statement with your min to control the values being passed into the min function.
MIN(IF [Price] > 0 then [Price] end)
I knew I was overlooking something simple.
how to get minimum non zero non negative value
report execution time
aa 20 sec
aa 10 sec
aa 30 sec
output shall be 10 sec but tableau returns 0 on doing min which is obvious. but I wish to see the minimum non zero non negative value.
can anybody please help