Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
OTBI Analysis - Early Leavers (Issue with Arithmetic functions on flex field)
Summary
Facing issue while applying Functions on Custom field in OTBIContent
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:
0