KPI: Revenue
Property | Value |
Associated measure group | Sales Summary |
Description | Total revenue from operations. |
Display folder | Financial Perspective\Grow Revenue |
Status indicator | Cylinder |
Trend indicator | Standard Arrow |
[Measures].[Sales Amount] |
Case When IsEmpty ( ParallelPeriod ( [Date].[Fiscal].[Fiscal Year], 1, [Date].[Fiscal].CurrentMember ) ) Then [Measures].[Sales Amount] Else 1.15 * ( [Measures].[Sales Amount], ParallelPeriod ( [Date].[Fiscal].[Fiscal Year], 1, [Date].[Fiscal].CurrentMember ) ) End |
Case When KpiValue( "Revenue" ) / KpiGoal( "Revenue" ) > 1 Then 1 When KpiValue( "Revenue" ) / KpiGoal( "Revenue" ) <= 1 And KpiValue( "Revenue" ) / KpiGoal( "Revenue" ) >= .85 Then 0 Else -1 End |
Case When IsEmpty ( ParallelPeriod ( [Date].[Fiscal].[Fiscal Year], 1, [Date].[Fiscal].CurrentMember ) ) Then 0 When VBA!Abs ( ( KpiValue( "Revenue" ) - ( KpiValue( "Revenue" ), ParallelPeriod ( [Date].[Fiscal].[Fiscal Year], 1, [Date].[Fiscal].CurrentMember ) ) ) / ( KpiValue( "Revenue" ), ParallelPeriod ( [Date].[Fiscal].[Fiscal Year], 1, [Date].[Fiscal].CurrentMember ) ) ) <=.02 Then 0 When ( KpiValue( "Revenue" ) - ( KpiValue( "Revenue" ), ParallelPeriod ( [Date].[Fiscal].[Fiscal Year], 1, [Date].[Fiscal].CurrentMember ) ) ) / ( KpiValue( "Revenue" ), ParallelPeriod ( [Date].[Fiscal].[Fiscal Year], 1, [Date].[Fiscal].CurrentMember ) ) >.02 Then 1 Else -1 End |