Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have attached the Sample_Data and also the code developed.
Referring to the Sample Data the "Status" Column Highlighted in Yellow Needs to be created and i have created it as:
if(IsNull(Last_working_day),'Active','Inactive') as Status_Check,
Hence now i needed Count of Emp_code based selection of Month Field, If any month selected it should show two KPI's with Count of Active employees and Count of Inactive employees.
Blank Rows in Last_working_day indicates active employee and with last date indicates inactive employee.
I used the below code:
=Count({<Status_Check='Inactive'>}Emp_Code)
=Count({<Status_Check='Active'>}Emp_Code)
=Count({<Last_working_day={"Len(Trim(Last_working_day))=0"}>}Emp_Code)
But with any of the above Codes i dont get the count, it gives me zero.
Please please let me know if there is anything wrong the script or code.
try missingcount()