Database Reference
In-Depth Information
case
when kpivalue("Internet Sales KPI") /
kpigoal("Internet Sales KPI") >= 1
then 1
when kpivalue("Internet Sales KPI") /
kpigoal("Internet Sales KPI") < 1
and kpivalue("Internet Sales KPI") /
kpigoal("Internet Sales KPI") > .7
then 0
else -1
end
The
case
formula checks the division between
kpivalue
and
kpigoal
; if
it is equal to or larger than
1
, it is specified as 1 or green.
When the result is below
1
but over
0.7
, it is specified as
0
or yellow. In all
other cases, it is set to
-1
or red.
9. Specify the value of
Trend indicator
to be
Standard arrow
.
10.
Trend expression
is a bit more complex, specify its value to be the following:
case
when isempty(
parallelperiod(
[Order Date].[Hierarchy].[Calendar Year],
1,
[Order Date].[Hierarchy].currentmember
)
)
then 0
when (vba!abs(
kpivalue("Internet Sales KPI")
-
(
kpivalue("Internet Sales
Search WWH ::
Custom Search