Exception Aggregation Average (AV1)

Use

You want to calculate the average of an overall value by day. The query looks like this:

From Date	To Date	Period of Time in Days	Value	Period of Time in Days Multiplied by Value
20050618	20050620	2	3	6
20050620	20050625	5	2	10
20050625	20050629	4	2	8
20050629	20050630	1	27	27
20050630	20050708	8	44	352
20050708	20050807	30	1	30
20050807	20050807	1	0	0
	Total	51	79	433

You calculate the average as follows:

433 : 51 = 8,490

To get this result, the key figure must have the exception aggregation Average (AV1), relating to the characteristic Calendar Day (0CALDAY).

For a key figure with the exception aggregation Average (AV1) relating to the characteristic Calendar Month (0CALMONTH), the result is as follows:

From Date	To Date	Period of Time in Days	Value	Period of Time in Days Multiplied by Value
200506	200506	30	3	90
200506	200506	30	2	60
200506	200506	30	2	60
200506	200506	30	27	810
200506	200507	61	44	2684
200507	200508	62	1	62
200508	200508	31	0	0
	Total	274	79	3766

You calculate the average as follows:

3766 : 274 = 13,744