Set Analysis expression for the below

[amars]

Hi all

Expression 1. :

Count(Distinct If(Not IsNull([Sep Date]) and MonthStart(AsOnMonth)= MonthStart([Sep Date]),[Emp ID]))

Expression 2. :

=(Count(Distinct If(Not IsNull([Sep Date]) and [Sep Date] >= FinancialStartDate and [Sep Date]<=MonthEnd(AsOnMonth), [Emp ID]))/
(Count(Distinct If([Part of Headcount]='Yes' ,Unique_Key))/Count(Distinct [Start Date For Month])))
* (12/Max(FinancialMonth))

Can Anyone tell me the equivalent Set Analysis Expression for the same. Thanks in advance.

With Regards

Amar

[martin59]

Hi,

For your first expression :

=Count({<[Sep Date]={">0"}, AsOnMonth={">=$(=MonthStart([Sep Date])) <=$(=MonthStart([Sep Date]))"}>} [Emp ID])

For your second expression :

Count({<[Sep Date]={">= $(=Only(FinancialStartDate)) <= $(=MonthEnd(AsOnMonth))"}>} DISTINCT [Emp ID]) / (Count({<[Part of Headcount]={Yes}>} DISTINCT Unique_Key) / Count(Distinct [Start Date For Month])) * (12/Max(FinancialMonth))

I'm not sur but I hope that helps you