KB47989: The average of the metric value is not displayed correctly at day of week level.

SYMPTOM:
 
In Strategy Developer 9.x, the average of the metric value is not displayed correctly at the day of week level, as shown in the image below:
 

 
The report shows data from 16th July to 15th August.
For instance, the number for Sundays in August is 2. It should be displayed as 50/2 = 25.
 
STEPS TO REPRODUCE:

• Apply the filter from 16th July to 15th August. The days on the lookup table are displayed correctly.
  

• Add the ‘Sales’ metric to the report and set the “Preserve all lookup table VLDB proeprty” to the 4th option. The report is displayed as shown in the image below:
  

• Add ‘Avg’ metric  (Avg(Sales) {~, Weekday}). Note that the metric value shows incorrect values. 

CAUSE:
 
This is by design. The average metric shows the value divided by the number of the entries in the fact table at day of week level.
 
ACTION:
 
Create a metric which divides the value by the number of week days, as shown below:

 
Avg - Weekday:

(Sum(Sales) {~, Weekday}  / Count(Day) {~, Weekday} )