Value Management Dashboard - Formulas of graphs in 'Quick View'

Graph 1: Achievement History

Deviation from Target value in percent

Formula:

(Baseline – Kpi value) / ( Baseline – Target value) *100

Graph 2: Plan/Actual History

Deviation of KPI value to Set Value in %

Formula:

((KPI value / Set value)*100) - 100

Graph 3: KPI Value History

Measurement points (= Measurement line) in comparision to Baseline (= starting date / starting value), Target (=Target value / target date) and Set value

Formula: -

Graph 4: Monthly Improvement History

Current value in comparison to previous value (increase or descrease)

Formula:

(( KPI value current * 100 ) /  KPI value previous ) -100