Transform if in set Analysis

[#1]

Count( if(date_start <= date(vdateNum), and (date_etabl > date(vdateNum) or ISNULL(date_etabl)=-1) and (date_branch > date(vdateNum) or ISNULL(date_etabl) =-1), employee_id,0))

How can put this in Set analysis ?

Thx,

[jvitantonio]

Hi try this:

count( {$<date_start = {>=date(vdateNum)}, date_etabl = {>=date(vdateNum), NULL}, date_branch = {>=date(vdateNum), NULL} >} employee_id)

[#3]

Hi,

You can do this  by using flags.

Make a flag in you script like:

if(date_start <= date(vdateNum), and (date_etabl > date(vdateNum) or ISNULL(date_etabl)=-1) and (date_branch > date(vdateNum) or ISNULL(date_etabl) =-1),1,0) as Flag

succes,

Halmar

[#4]

Thanks !!