excluding zero values of other field from count distinct

[chan103148]

good day,

my fields are:

Traffic In

Tseq No

I want to compute for the conversion

Count(distinct [Tseq No])/Sum([Traffic In])

how can I disregard Tseq No that has corresponding Traffic In value equivalent to zero in the computation?

thank you.

[anushree1]

Go to Add ons -> Data Handling->Uncheck Include Zero Values

[chan103148]

its not working

i need to remove "Transaction count" with corresponding zero "Traffic In" in the formula.

[anushree1]

can you share the sample file please.

[chan103148]

here

[anushree1]

Add an if condition on all the expressions like:

=if(sum(traffic)>0,Sum(transactions))

if(sum(traffic)>0,Sum([Ave price]))

and so on.. This should fix the issue 

[chan103148]

Count(distinct [Tseq No])/Sum([Traffic In])

*Tseq No  is transactions

*Traffic In is traffic

how can i remove transaction count with corresponding zero traffic in the formula above.

[chan103148]

there are dates that has transactions but no traffic count.

[anushree1]

Use this:

if(sum(traffic)>0,Count(distinct transactions)/Sum(traffic))

[chan103148]

not working 😞