Categories
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.
Comments
-
Did you try to use Aggregate as Sum and By column All values or set of Column name.
0 -
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.
0 -
Since we have a resolution, can we close this idea?
Thanks.
1 -
Yes You can close the Idea.
0
