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

OTBI Caclulation Issue [nQSError: 22025] Function Cast is called with an incompatible type. (HY000)

in Reporting and Analytics for HCM 2 comments

Summary:

Hi everyone,

I'm finding troubles when summing 2 columns in OTBI.

Content (please ensure you mask any confidential information):

Hi everyone,

I'm finding troubles when summing 2 columns in OTBI.

When I try to sum

FILTER( "Assignment Event"."Event Headcount" USING "Worker"."Employee Gender" = 'Female' AND DESCRIPTOR_IDOF("Workforce Management - Worker Assignment Event Real Time"."Assignment Event Details"."Assignment Status Type") IN ('ACTIVE', 'SUSPENDED') AND TO_DATETIME((@{AsOfDate}) - 30, 'DD-MM-YYYY') BETWEEN TO_DATETIME("Assignment Event Details"."Effective Start Date", 'DD-MM-YYYY') AND TO_DATETIME("Assignment Event Details"."Effective End Date", 'DD-MM-YYYY') )

+

FILTER( "Assignment Event"."Event Headcount" USING "Worker"."Employee Gender" = 'Female' AND DESCRIPTOR_IDOF("Workforce Management - Worker Assignment Event Real Time"."Assignment Event Details"."Assignment Status Type") IN ('ACTIVE', 'SUSPENDED') AND TO_DATETIME((@{AsOfDate}) - 30,'DD-MM-YYYY') BETWEEN TO_DATETIME("Assignment Event Details"."Effective Start Date", 'DD-MM-YYYY') AND TO_DATETIME("Assignment Event Details"."Effective End Date",'DD-MM-YYYY') )

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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