aggr inside set analysis

[harleen_singh]

Hello ,

               i want to use aggrageta inside this set analysis how to do that?

count(  { $< EmployeeNo = P ({<Date = {"$(MinDate)"}>} EmployeeNo )/ P ({<Date = {"$(Lastdate)"}>} EmployeeNo )>} EmployeeNo)

for example i want aggr following with Date and one more dimension say "Company ID" and use it inside above expression.

P ({<Date = {"$(MinDate)"}>} EmployeeNo)

thanks

Lavi

[#2]

Hi,

You can try this statement.

aggr(count({$< EmployeeNo = P ({<Date = {"$(MinDate)"}>} EmployeeNo )/

P ({<Date = {"$(Lastdate)"}>} EmployeeNo )>} EmployeeNo),Date,CompanyID)

Regards,

Janzen

[harleen_singh]

Janzen Jino B,

                            i have already tried but it didn't work. I want to try inside the set analysis.

thanks

[#4]

hi,

Could you please attach a sample file?

Regards,

Janzen

[harleen_singh]

Janzen,

              attached is the sample. If you look at the expression - (minus) i have used above formula.

if you check company id 0102

it shows 1 in -(minus) which is wrong but when u select 0102 it gives u correct figure i.e 3 .

thanks

Lavi

[harleen_singh]

Janzen Jino B,

                         u checked out sample??

thanks

Lavi