KPI: Revenue

CollapseAll image

Collapse image KPI properties


 Property   Value 
 Associated measure group   Sales Summary 
 Description   Total revenue from operations. 
 Display folder   Financial Perspective\Grow Revenue 
 Status indicator   Cylinder 
 Trend indicator   Standard Arrow 

Collapse image Value expression


[Measures].[Sales Amount]

Collapse image Goal expression


Case
    When IsEmpty
         (
           ParallelPeriod
           (
             [Date].[Fiscal].[Fiscal Year],
             1,
             [Date].[Fiscal].CurrentMember
           )
         )
    Then [Measures].[Sales Amount]              
    Else 1.15 *
         ( 
           [Measures].[Sales Amount],
           ParallelPeriod
           (
             [Date].[Fiscal].[Fiscal Year],
             1,
             [Date].[Fiscal].CurrentMember
           )
         )
End

Collapse image Status expression


Case
    When KpiValue( "Revenue" ) / KpiGoal( "Revenue" ) >  1
    Then 1
    When KpiValue( "Revenue" ) / KpiGoal( "Revenue" ) <= 1
         And 
         KpiValue( "Revenue" ) / KpiGoal( "Revenue" ) >= .85
    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( "Revenue" ) 
            - 
            (
              KpiValue( "Revenue" ),
              ParallelPeriod
              ( 
                [Date].[Fiscal].[Fiscal Year],
                1,
                [Date].[Fiscal].CurrentMember
              )
            )
          ) 
          /
          (
            KpiValue( "Revenue" ),
            ParallelPeriod
            ( 
              [Date].[Fiscal].[Fiscal Year],
              1,
              [Date].[Fiscal].CurrentMember
            )
          )  
         ) <=.02
    Then 0
    When ( 
           KpiValue( "Revenue" ) 
           - 
           (
             KpiValue( "Revenue" ),
             ParallelPeriod
             ( 
               [Date].[Fiscal].[Fiscal Year],
               1,
               [Date].[Fiscal].CurrentMember
             )
           ) 
         )
         /
         (
           KpiValue( "Revenue" ),
           ParallelPeriod
           ( 
             [Date].[Fiscal].[Fiscal Year],
             1,
             [Date].[Fiscal].CurrentMember
           )
         ) >.02
    Then 1
    Else -1
End

Collapse image See also


About this documentation