Count the person who is transfer within factories

[VishalWaghole]

Dear friends,

I have issue regarding my set analysis.

My scenaria is, i have multiple factories, and i want count employee transfer within factories.

i have written expression, but transfer count is not going to be display until i select employee number
which is transfer.

My requirment is to display the count once i select Year, Month and factory name.

Thanks and Regards,

Vishal Waghole.

[khadeer]

Can you post ur sample data.

[VishalWaghole]

Here i upload my test file, i cant put data here coz that data coming from multiple tables.

but here in my application.

If we select

Year as 2013.

Month as Jan

Location as HR Aurangabad

and Employee number as 11003263

then Transfer in column show 1 value.

but my requirment is that without  selecting Employee number i want that count.

Thanks

Vishal

[swuehl · Accepted solution]

You probably need to embed your condition inside the aggregation, not the other way around, e.g. for Transfer In Month:

=sum(

aggr(

count({<MIN_EFFECTIVE_START_DATE_MONTH = {"$(=Maxstring(MonthYear))"},ACTUAL_TERMINATION_DATE_FALG = {LIVE}>} distinct

if(START_DATE <> MIN_EFFECTIVE_START_DATE,PERSON_ID))

,HLA_LOCATION_CODE,OU_NAME)

)

[#5]

You can try with below expression for Transfer in Month of

sum(aggr(count  (distinct if(START_DATE <> MIN_EFFECTIVE_START_DATE and ACTUAL_TERMINATION_DATE_FALG = 'LIVE' and MIN_EFFECTIVE_START_DATE_MONTH = 'Jan 2013',PERSON_ID)),HLA_LOCATION_CODE,OU_NAME))

instead of jan 2013 you can store month in a variable and use it

[VishalWaghole]

Thanks swuehl its working..