KPI: Channel Revenue
KPI properties
| Property | Value |
| Associated measure group | Reseller Sales |
| Description | Revenue realized through the reseller sales channel. |
| Display folder | Financial Perspective\Grow Revenue |
| Status indicator | Cylinder |
| Trend indicator | Standard Arrow |
Value expression
[Measures].[Reseller Sales Amount] |
Goal expression
[Measures].[Sales Amount Quota] |
Status expression
Case When KpiValue( "Channel Revenue" ) / KpiGoal( "Channel Revenue" ) > 1 Then 1 When KpiValue( "Channel Revenue" ) / KpiGoal( "Channel Revenue" ) <= 1 And KpiValue( "Channel Revenue" ) / KpiGoal( "Channel Revenue" ) >= .85 Then 0 Else -1 End |
Trend expression
Case When IsEmpty ( ParallelPeriod ( [Date].[Fiscal].[Fiscal Year], 1, [Date].[Fiscal].CurrentMember ) ) Then 0 When VBA!Abs ( ( KpiValue( "Channel Revenue" ) - ( KpiValue( "Channel Revenue" ), ParallelPeriod ( [Date].[Fiscal].[Fiscal Year], 1, [Date].[Fiscal].CurrentMember ) ) ) / ( KpiValue( "Channel Revenue" ), ParallelPeriod ( [Date].[Fiscal].[Fiscal Year], 1, [Date].[Fiscal].CurrentMember ) ) ) <=.02 Then 0 When ( KpiValue( "Channel Revenue" ) - ( KpiValue( "Channel Revenue" ), ParallelPeriod ( [Date].[Fiscal].[Fiscal Year], 1, [Date].[Fiscal].CurrentMember ) ) ) / ( KpiValue( "Channel Revenue" ), ParallelPeriod ( [Date].[Fiscal].[Fiscal Year], 1, [Date].[Fiscal].CurrentMember ) ) >.02 Then 1 Else -1 End |
See also