Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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, imho you need " instead of ' around the >0 (it's a search string):
(Sum({<SalesMount={">0"},YearlyTotal = {[Year 3]}>}SalesAmount)/156)/count(DISTINCT ItemNumber)
(Sum({<SalesMount={'>0'},YearlyTotal = {[Year 3]}>}SalesAmount)/156)/count(DISTINCT ItemNumber)
@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)