List Of Variables:
1. vMarineHRExp:
pick(match($(vMarineHR), 1, 2, 3,4)
//Recruitment
, count({<[MHR._SourceFlag]={'Recruitment'},MHR.STATUS={'APPROVED'}
, $1
>} distinct MHR.map_id)
,//Promotion
count({<MHR._SourceFlag={'Promotion'}
, $1
>} distinct MHR.CPM_ID)
,//Resignation
Count({<MHR.STATUS ={'FINALISED'},[MHR._SourceFlag]={'ResignationDismissal'},MHR.CTE_TYPE={'RESIGNATION'}
, $1
>} distinct MHR.CrewID)
,
//Dismissal
Count({<MHR.STATUS ={'FINALISED'},[MHR._SourceFlag]={'ResignationDismissal'},MHR.CTE_TYPE={'DISMISSAL'}
, $1
>} distinct MHR.CrewID)
)
2. vMarineHRPeriodFilter:
pick(match($(vMarineHRFlag), 1, 2, 3)
,//Current month
'CalendarPeriod={$(=max(CalendarPeriod))}'
,//YTD
'CalendarYear={$(=max(CalendarYear))},CalendarPeriod={"<=$(=max(CalendarPeriod))"}'
,//Rolling 12 months
'CalendarPeriod={">=$(=vLast12Month) <=$(=vCurrentMonth)"}'
)
and added set analysis as
=$(vMarineHRExp(vMarineHRPeriodFilter))
just wanted to change my filter condition based on user input (filter can be : cureent month / YTD/Rolling 12 months)
so i have created vMarineHRPeriodFilter variable to finalize my filter and use this in my parameter set analysis vMarineHRExp
but its not working properly ... 😞
