Dear All,
I have one requirement where I need to calculate Unique No. of Employees Till Date(YTD) as well as For the Month(FTM)
Here I need to use condition => Overall Training Man Days of that Employee should be greater than or equal to 2.
I have attached sample file for this scenario & what is expected output as well.
------ (Result)
YTD Till Month (From Apr-13 To Till Date)
= Count( Financial Year = '2013-2014' AND DISTINCT (Sum([Training Man Days])>=2) [Emp ID] ) ------ (9)
FTM (For Any Particular Month say May-13)
= Count( Month='May-13' AND DISTINCT (Sum([Training Man Days])>=2) [Emp ID] ) ------- (3)
So, Result of this I have written in brackets.
It will be greatly helpful if anybody can come up with the solution.
-Thanks & Regards,
Kiran
