KPI: Product Gross Profit Margin
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 |
[Measures].[Gross Profit Margin] |
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 |
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 |
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 |