Exclude Zero value on an expression

[#1]

Hi,

Hi,

how to exclude Zero value on an Expression?

[Anonymous]

You didn't tell what expression.  for the generic question, I can give a generic answer:

<an aggregation function> ({<Value-={0}>} Value)

[#3]

Hi,

below is my expression

if(Count(CustomerCodeName)>0,sum(aggr(count(DISTINCT SalesmanDate),CustomerCodeName,SalesmanDate)))

[Anonymous]

This is better

Try this, it will work unless I miscounted the parenthesis:

sum(if(

aggr(count(DISTINCT SalesmanDate),CustomerCodeName,SalesmanDate)>0,

aggr(count(DISTINCT SalesmanDate),CustomerCodeName,SalesmanDate)

))