KPI: Product Gross Profit Margin
KPI properties
| Property | Value |
| Associated measure group | Sales Summary |
| Description | Total profit earned as a percentage of sales. |
| Display folder | Financial Perspective\Maintain Overall Margins |
| Status indicator | Cylinder |
| Trend indicator | Status Arrow - Ascending |
Value expression
[Measures].[Gross Profit Margin] |
Goal expression
Case When [Product].[Category].CurrentMember Is [Product].[Category].[Accessories] Then .40 When [Product].[Category].CurrentMember Is [Product].[Category].[Bikes] Then .12 When [Product].[Category].CurrentMember Is [Product].[Category].[Clothing] Then .20 When [Product].[Category].CurrentMember Is [Product].[Category].[Components] Then .10 Else .12 End |
Status expression
Case When KpiValue( "Product Gross Profit Margin" ) / KpiGoal ( "Product Gross Profit Margin" ) >= .90 Then 1 When KpiValue( "Product Gross Profit Margin" ) / KpiGoal ( "Product Gross Profit Margin" ) < .90 And KpiValue( "Product Gross Profit Margin" ) / KpiGoal ( "Product Gross Profit Margin" ) >= .80 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( "Product Gross Profit Margin" ) - ( KpiValue( "Product Gross Profit Margin" ), ParallelPeriod ( [Date].[Fiscal].[Fiscal Year], 1, [Date].[Fiscal].CurrentMember ) ) ) / ( KpiValue( "Product Gross Profit Margin" ), ParallelPeriod ( [Date].[Fiscal].[Fiscal Year], 1, [Date].[Fiscal].CurrentMember ) ) ) <=.02 Then 0 When ( KpiValue( "Product Gross Profit Margin" ) - ( KpiValue( "Product Gross Profit Margin" ), ParallelPeriod ( [Date].[Fiscal].[Fiscal Year], 1, [Date].[Fiscal].CurrentMember ) ) ) / ( KpiValue( "Product Gross Profit Margin" ), ParallelPeriod ( [Date].[Fiscal].[Fiscal Year], 1, [Date].[Fiscal].CurrentMember ) ) >.02 Then 1 Else -1 End |
See also