Case
When IsEmpty
(
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
)
Then 0
When VBA!Abs
(
(
KpiValue( "Channel Revenue" )
-
(
KpiValue( "Channel Revenue" ),
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
)
)
/
(
KpiValue( "Channel Revenue" ),
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
)
) <=.02
Then 0
When (
KpiValue( "Channel Revenue" )
-
(
KpiValue( "Channel Revenue" ),
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
)
)
/
(
KpiValue( "Channel Revenue" ),
ParallelPeriod
(
[Date].[Fiscal].[Fiscal Year],
1,
[Date].[Fiscal].CurrentMember
)
) >.02
Then 1
Else -1
End
|