Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
COUNT IF in a column — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

COUNT IF in a column

Received Response
54
Views
2
Comments
in Reporting and Analytics for HCM 2 comments

Summary:

Replicate the COUNT IF condition in a column

Content (required):

Hi All,

I need to replicate this KPI in a column of analysis:

In details, I don't find the correct criteria to use to replicate the blue box condition. My tests are:

1) COUNT (CASE WHEN ((DESCRIPTOR_IDOF("Workforce Management - Worker Assignment Real Time"."Worker"."Assignment Status Type") NOT IN ('INACTIVE', 'INACTIVE_PAID')) AND (COUNT ("Worker"."Assignment Number" BY "Worker"."Person Number","Worker"."Assignment Status Type") > 1) ) THEN "Worker"."Person Number" ELSE NULL END) --> result is not correct

2) COUNT( DISTINCT CASE WHEN ((FILTER ((COUNT ("Worker"."Assignment Number" BY "Worker"."Person Number","Worker"."Assignment Status Type")) USING (DESCRIPTOR_IDOF("Workforce Management - Worker Assignment Real Time"."Worker"."Assignment Status Type") NOT IN ('INACTIVE', 'INACTIVE_PAID'))))>1) THEN "Worker"."Person Number" ELSE NULL END) 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!