Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
IF(NUM(FinCalculatedDate) = FLOOR(NUM(VCalculated_Date)) AND EmpStatus_Code = '3' and Leave_AbsenceDays = 0 ,Employee_Code)`
Regards,
QA
Hi,
I think this is your need.
=Only({<FinCalculatedDate={$(=Date(VCalculated_Date))},EmpStatus_Code = {'3' },Leave_AbsenceDays = {0 }>} Employee_Code )
Hope it helps
Celambarasan
Hi Celambarasan,
But i want to use this expression in Dimension Part so ONLY will not be usefull.
My requirement is NOT to count Employees satisfying the avobe condition,But to list them out...
Thanks,
QA
Hi,
Instead of restricting it in dimension part you can do it in the expression part.Is there any problem in doing it in expression part?
Celambarasan
Hi,
What are the Dimensions and expressions in your chart. If you chart has any expression then use the Set analysis part of the expreesion and use Employee_Code as dimension. The dimension is automatically filtered by the expression results.
Regards,
jagan.
Hi Akumar,
Just enclosed Celambarasan's expression in AGGR() function.
Example:
AGGR(Only({<FinCalculatedDate={$(=Date(VCalculated_Date))},EmpStatus_Code = {'3' },Leave_AbsenceDays = {0 }>} Employee_Code ), Employee_Code)
Regards,
Ronald