Im struggling with an expression at the minute. I have a MIN/List in which I want to select the lowest value in a list of prices.
However, we may not acquire all prices so we input values of “0.00”. On these occassions the 0 value is the lowest and presents itself.
Is there an expression that can exclude this? I have tried "NOT(CONTAINS) and such but I would have to do that for every column and I’m not sure how it fits in terms of the LIST expression.