KPI properties
| name | value |
|---|
| name | Financial Variance
|
| description | The difference between actual and budgeted values for a given account.
|
| id | KPI 4
|
| display folder | Financial Perspective\Grow Revenue
|
| associated measure group id | Financial Reporting
|
| trend graphic | Status Arrow - Descending
|
| status graphic | Variance Arrow
|
Value
( [Scenario].[Scenario].[Scenario].[Budget Variance %], [Measures].[Amount] )
Goal
// Variance should be as close to zero as possible.
0
Status
Case
When VBA!Abs
(
KpiValue( "Financial Variance" )
) <= .05
Then 1
When VBA!Abs
(
KpiValue( "Financial Variance" )
) > .05
And
VBA!Abs
(
KpiValue( "Financial Variance" )
) <= .10
Then 0
Else -1
End
Trend
Case
When IsEmpty
(
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
)
Then 0
When VBA!Abs
(
(
KpiValue( "Financial Variance" )
-
(
KpiValue( "Financial Variance" ),
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
)
)
/
(
KpiValue( "Financial Variance" ),
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
)
) <=.02
Then 0
When (
KpiValue( "Financial Variance" )
-
(
KpiValue( "Financial Variance" ),
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
)
)
/
(
KpiValue( "Financial Variance" ),
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
) >.02
Then 1
Else -1
End