Listing Values that do not contain value 0

[Sarah_Keown]

Hi all,

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.

[hru · Accepted solution]

How about:

	MIN(
		(LIST([Oventrop App Price], [Beggs and Partners App Price])
		- LIST(0.00))
	)

[Sarah_Keown]

This is great, thank you!