2 Variables in set analisys

Anonymous — Wed, 26 Jun 2013 03:20:34 GMT

hi,

i need to count feild with 2 Variables, in expression.

count date when type=regular & billets is greater then 3.

i wrote like this, but i get nothing :

count(DISTINCT{<type='regular''},sum(DISTINCT([billets)>={4})>}start date

how i need to write it ?

thanks'

yarin.

Re: 2 Variables in set analisys

Sokkorn — Wed, 26 Jun 2013 03:25:26 GMT

Hi Yarin,

Did you try this yet =Count({$<type = {'regular'}, billets = {">3"}>} DISTINCT [start date])

Regards,

Sokkorn