Help with set analysis formula

[francisvandergr]

Can someone help me with the formula. In a pivot table i have a dimension Year week.

Now i like to divide my expression with the count of values for that dimension. I enclosed an example.

[Gysbert_Wassenaar · Accepted solution]

Try:

sum(if(ProjectPlanning_PercentageGereed < '100',ProjectPlanning_Uren)) / count(total <ProjectPlanningFase_ID> distinct if(ProjectPlanning_PercentageGereed < '100',Planning_JaarWeek))