Adventure Works DW - Kpi - Financial Gross Margin

KPI properties

name	value
name	Financial Gross Margin
description	The percentage of every dollar earned that can be used to pay general and administrative expenses.
id	KPI 7
display folder	Financial Perspective\Maintain Overall Margins
associated measure group id	Financial Reporting
trend graphic	Status Arrow - Ascending
status graphic	Traffic Light

Value

// Account 49 = Gross Margin | Scenario 1 = Actual
( [Account].[Accounts].&[49], [Scenario].[Scenario].&[1], [Measures].[Amount] )

Goal

// Account 49 = Gross Margin | Scenario 2 = Budget
( [Account].[Accounts].&[49], [Scenario].[Scenario].&[2], [Measures].[Amount] )

Status

Case
    When KpiValue( "Financial Gross Margin" ) / 
         KpiGoal ( "Financial Gross Margin" ) >= .95
    Then 1
    When KpiValue( "Financial Gross Margin" ) / 
         KpiGoal ( "Financial Gross Margin" ) <  .95
         And 
         KpiValue( "Financial Gross Margin" ) / 
         KpiGoal ( "Financial Gross Margin" ) >= .85
    Then 0
    Else -1
End

Trend

Case
    When IsEmpty
         (
           ParallelPeriod
           (
             [Date].[Fiscal].[Fiscal Year],
             1,
             [Date].[Fiscal].CurrentMember
           )
         )
    Then 0  
    When VBA!Abs
         (
          ( 
            KpiValue( "Financial Gross Margin" ) 
            - 
            (
              KpiValue( "Financial Gross Margin" ),
              ParallelPeriod
              ( 
                [Date].[Fiscal].[Fiscal Year],
                1,
                [Date].[Fiscal].CurrentMember
              )
            )
          ) 
          /
          (
            KpiValue( "Financial Gross Margin" ),
            ParallelPeriod
            ( 
              [Date].[Fiscal].[Fiscal Year],
              1,
              [Date].[Fiscal].CurrentMember
            )
          )  
         ) <=.03
    Then 0
    When ( 
           KpiValue( "Financial Gross Margin" ) 
           - 
           (
             KpiValue( "Financial Gross Margin" ),
             ParallelPeriod
             ( 
               [Date].[Fiscal].[Fiscal Year],
               1,
               [Date].[Fiscal].CurrentMember
             )
           ) 
         )
         /
         (
           KpiValue( "Financial Gross Margin" ),
           ParallelPeriod
           ( 
             [Date].[Fiscal].[Fiscal Year],
             1,
             [Date].[Fiscal].CurrentMember
           )
         ) >.03
    Then 1
    Else -1
End