Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
)
Can you post ur sample data.
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
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)
)
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
Thanks swuehl its working..