Skip to Content
0
Former Member
Feb 07, 2008 at 02:15 PM

Average Key Figure Calculation

16 Views

In my MultiProvider I have 2 key figures - PlanKF & ActualKF, dimension that has values for both key figures, say Dimension1 and PrognosisDate having values only for PlanKF.

I need to calculate average PlanKF accross Prognosis Date, for example:

detail rows in MProvider

===========================================

Dimension1 PrognosisDate PlanKF ActualKF

===========================================

DimValue1 20080101 200 250

DimValue1 20080102 200

DimValue1 20080103 500

===========================================

result must be:

===========================================

Dimension1 PlanKF ActualKF

===========================================

DimValue1 300 250

===========================================