BI Publisher SQL Dividing a Sum by Count Distinct
Summary
I am creating a new BI Publisher data model to analyze some expense report data. I need to divide a sum of values by a count(distinct) however, the result returned is showin as a tenth of the correctContent
Report to analyze average time taken to approve expense claims
Values are:
total no. of reports = count(distinct expense_report_num) = 1978
total time to approve = sum(expense_submit_date - expense_final_approval_date) = 23348
Need to divide total time to approve by total no. of reports. So I am using the following calculation:
(SUM(eer.final_approval_date - eer.report_submit_date)) / COUNT(DISTINCT
Tagged:
0