topic If in expression in QlikView

If in expression

Tue, 19 Mar 2013 13:19:45 GMT

I have the following expression. See below. But I only want that expression to work when the SalesAmount is > 0, How can I write this?

(Sum({<YearlyTotal = {[Year 3]}>}SalesAmount)/156)/count(DISTINCT ItemNumber)

Gysbert_Wassenaar — Tue, 19 Mar 2013 13:32:48 GMT

(Sum({<SalesMount={'>0'},YearlyTotal = {[Year 3]}>}SalesAmount)/156)/count(DISTINCT ItemNumber)

Wed, 20 Mar 2013 08:22:57 GMT

@Gysbert, imho you need " instead of ' around the >0 (it's a search string):

(Sum({<SalesMount={">0"},YearlyTotal = {[Year 3]}>}SalesAmount)/156)/count(DISTINCT ItemNumber)