Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Actual Value

Trend Arrow

Previous Period> Period > Current periodPeriod

Downwards

Previous Period = Current periodPeriod

Sideways

Previous Period< Period < Current periodPeriod

Upwards

Previous Period = Null; Current period Period = Not nullNull

N/A

Previous Period = Not Null; Current period Period = Null

N/A

Previous Period = Null; Current period Period = Null

N/A

Previous Period = 0;  Current period>0Period > 0

Upwards

Previous Period = 0;  Current periodPeriod = 0

Sideways

Previous Period > 0;  Current periodPeriod = 0

Downwards

Previous Period = 0;  Current period<0Period < 0

Downwards

Previous Period < 0;  Current periodPeriod = 0

Upwards

 Calculation method = Less is better

Actual Value

Trend Arrow

Previous Period> Period > Current periodPeriod

Upwards

Previous Period = Current periodPeriod

Sideways

Previous Period< Current periodPeriod

Downwards

Previous Period = Null; Current period Period = Not nullNull

N/A

Previous Period = Not Null; Current period Period = Null

N/A

Previous Period = Null; Current period Period = Null

N/A

Previous Period = 0;  Current period>0Period > 0

Downwards

Previous Period = 0;  Current periodPeriod = 0

Sideways

Previous Period > 0;  Current periodPeriod = 0

Upwards

Previous Period = 0;  Current period<0Period < 0

Upwards

Previous Period < 0;  Current periodPeriod = 0

Downwards

Calculation method= Goalpost

Actual Value

Trend Arrow

When Previous/ Current period Period ≠Target; |Target – Previous periodPeriod|> |Target- Current Period|

Upwards

When Previous/ Current period Period ≠Target; |Target – Previous periodPeriod|= |Target- Current Period|

Sideways

When Previous/ Current period Period ≠Target; |Target – Previous periodPeriod|< |Target- Current Period|

Downwards

Previous periodPeriod= Target; Current period Period ≠ Target

Downwards

Previous period≠ Period≠ Target; Current period Period = Target

Upwards

Previous periodPeriod= Target; Current period Period = Target

Sideways

Previous Period = Null; Current period Period = Not nullNull

N/A

Previous Period = Not Null; Current period Period = Null

N/A

Previous Period = Null; Current period Period = Null

N/A

When Previous/ Current period Period ≠Target; |Target – Previous periodPeriod|> |Target- Current Period|

Upwards

When Previous/ Current period Period ≠Target; |Target – Previous periodPeriod|= |Target- Current Period|

Sideways

...