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]

works for me.

Please check the attached ,I have put jus 2 expressions , you can add similar expressions , also check the Data Handing Section it should be unchecked for Include Zero Vaues if you do not add an if condition for Sum(Traffic)

[Kashyap_R]

Hi 

Try this expression for the date dimension

IF(traffic>0,Date)

Hope this helps

Thanks