KPI: Product Gross Profit Margin

CollapseAll image

Collapse image 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 

Collapse image Value expression


[Measures].[Gross Profit Margin]

Collapse image 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

Collapse image 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

Collapse image 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

Collapse image See also


About this documentation