Categories
- All Categories
- Oracle Analytics Learning Hub
- 32 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 255 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 95 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
AVG Calculation not calculating as expected in FDI.
I have written the below calculation to calculate Tenure for my workforce and when this is added to a table the calculation populates as expected.
However, when I try to average the calculation, it does not return the expected outcome
Is anyone able to assist with how this may be corrected?
I have also tried using Facts - Workforce Length of Service from Workforce Headcount Facts however, they do populate as expected either.
Thanks
Scott
Best Answer
-
Hi Scott,
Thank you for posting your question in Oracle Fusion Data Intelligence(FDI) Product Community.
for such Data issue we can debug by comparing logical and physical sql being generated for this avg calculation with the other calculation which is working and also running those sql in database to review the results as this will help us narrow down the cause :
If further help is needed to debug please log a SR and attach your dva file with logical and physical sql so that support can help investigate.
0
Answers
-
@Scott_Turner_ what was the resolution to this? We're having similar issues as well.
0
