Extending and Customizing Cubes - SQL Server Analysis Services 2012 Cube Development - page 150

ParallelPeriod
([Date].[Calendar].[Calendar
Year], 1,
[Date].[Calendar].CurrentMember))
Then 0
When VBA!Abs
((KpiValue( "Internet Order Growth"
)
-
(KpiValue( "Internet Order
Growth" ),
ParallelPeriod
([Date].[Calendar].[Calendar Year],
1,[Date].[Calendar].CurrentMember))
)
/
(
KpiValue( "Internet Order
Growth" ),
ParallelPeriod
([Date].[Calendar].[Calendar
Year],1,[Date].[Calendar].CurrentMember))
) <=.02
Then 0
When (KpiValue( "Internet Order
Growth" )
-
(KpiValue( "Internet Order
Growth" ),
ParallelPeriod
([Date].[Calendar].[Calendar
Year],1,[Date].[Calendar].CurrentMember))
)
/
(KpiValue( "Internet Order
Growth" ),
ParallelPeriod([Date].[Calendar].[Calendar