Issue with Bins and Case Statement — 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

Issue with Bins and Case Statement

edited Jun 12, 2018 2:07PM in Reporting and Analytics for HCM 1 comment

Summary

Issuing a CASE statement against hire and term bins from Action Name field

Content

Due to our decentralization I cannot utilize the assignment event measures when reporting our hires and terminations.  So what I've done is create a bin for hires and a bin for terminations utilizing the action name field.  Since this report will also have month ending HC, I cannot simply filter by those bins to get only my terms and hires, because it will also filter the month end HC number.  To fix this I'm trying to write a case statement to give me an assignment event count only by those two bins, but for whatever reason it's not working.  Can someone help?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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