Oracle Communities

Oracle Analytics and AI

Child Item

OAC DV - Custom Calcs - Sum the Results of Calculations instead of Calculating at the Summary Level

I created a custom calculation in OAC – DV to get a count distinct for the number of task that each team member performed in a day. We were assigning a time loss for each time they had to switch a task in a day. We needed to sum the results of the calculation. DV calculates the count distinct at the summary level. This caused us to export to Excel to get the correct calculation. See attached PDF of results from DV vs Exporting to Excel.

Summary of Custom Calcs.pdf

Find more posts tagged with

Delivered

Status: Delivered

Comments

ALOK SH-Oracle

Did you try to use Aggregate as Sum and By column All values or set of Column name.

Cathye_Pendley

ALOK SH-Oracle,

Thanks for responding so quickly. Yes, I had tried that and couldn't get it to work, but when I did go back into it this morning, I did see another option that I thought I had tried before - when I tested it this morning, it seems to fix by issues. See what I did below:

Number of Days:

I have the Grand Total and Subtotal set as below:

The screenshot below shows the calculation is being done at the Grand Total and Subtotal level instead of summing up the calculations.

If I set the Total Aggregation to Sum it seems to fix the issue.

Cathye_Pendley

Since we have a resolution, can we close this idea?

Thanks.

ALOK SH-Oracle

Yes You can close the Idea.