KPI properties
| name | value |
|---|
| name | Net Income
|
| description | Total earnings less operating expenses, taxes, interest, depreciation and other expenses.
|
| id | KPI 12
|
| display folder | Financial Perspective\Maintain Overall Margins
|
| associated measure group id | Financial Reporting
|
| trend graphic | Status Arrow - Ascending
|
| status graphic | Road Signs
|
Value
// Account 47 = Net Income | Scenario 1 = Actual
( [Account].[Accounts].&[47], [Scenario].[Scenario].&[1], [Measures].[Amount] )
Goal
// Account 47 = Net Income | Scenario 2 = Budget
( [Account].[Accounts].&[47], [Scenario].[Scenario].&[2], [Measures].[Amount] )
Status
Case
When KpiValue( "Net Income" ) / KpiGoal( "Net Income" ) >= .95
Then 1
When KpiValue( "Net Income" ) / KpiGoal( "Net Income" ) < .95
And
KpiValue( "Net Income" ) / KpiGoal( "Net Income" ) >= .85
Then 0
Else -1
EndTrend
Case
When IsEmpty
(
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
)
Then 0
When VBA!Abs
(
(
KpiValue( "Net Income" )
-
(
KpiValue( "Net Income" ),
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
)
)
/
(
KpiValue( "Net Income" ),
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
)
) <=.03
Then 0
When (
KpiValue( "Net Income" )
-
(
KpiValue( "Net Income" ),
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
)
)
/
(
KpiValue( "Net Income" ),
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
) >.03
Then 1
Else -1
End