Workdays per month Aggr to Quarter

[pauldamen]

All,

I have a calculation were we calculate the average workdays per month for a country or region (region is average, on country level the average is just that number) for example: country 1 has 20 workdays, country 2 has 22. The average for the region is 21.

Now I need to have the # of workdays for a Quarter which should be calculated by adding the average of month 1 + month 2 + month 3. But how can I achieve this, because of the average is always calculate the average even with the quarter as a dimension, taking this average and do it times 3 causes differences so that doesn't work either.

Help is much appreciated.

Regards,

Paul

[swuehl]

I believe that you shouldn't add the averages, but calculate the workdays per quarter per country and average across countries.

If you tell us more about how you calculate the workdays and in what context you are doing this, I think someone can suggest a way to do this.