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 Analysis - Early Leavers (Issue with Arithmetic functions on flex field)

edited Oct 16, 2019 6:10AM in Reporting and Analytics for HCM 8 comments

Summary

Facing issue while applying Functions on Custom field in OTBI

Content

Hello,

We have 1 requirement for an analysis that will give separation count of associates who resign within 30 days/60 days etc. I have prepared 1 OTBI analysis with columns as Days of Service, Separation count. I have used logic "Count (Person Number)" for Separation Count, but result is reflecting as 0. On the other hand, when I include only “Person Number” results are reflecting correct. It seems to be some issue on applying different functions (sum, count, add) for flex fields. In this analysis, I am using flex field for DOJ to calculate days of Service (TIMESTAMPDIFF(SQL_TSI_DAY,DOJ,Termination Date)).

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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