Comparisons

Absolute Comparisons

Absolute comparisons simply calculate the delta between the data points.

Relative Comparison - Default 

The relative comparison is calculated as:

| (Avalue / first value) -1 | * signum(second value - first value)

or in simple words: "The relative percentage change with the sign of the absolute change."

Relative Comparison - Simple

The simple comparison calculates the percentage difference as:

(second value / first value) -1

The drawback of this comparison scheme is, that it produces negative values on a negative base. Although the change is usually "positive" - at least from a business perspective. Use the default relative comparison to circumvent this problem.

CAGR - Cumulated Average Growth Rate

Calculates the average growth necessary over the given years to reach the second value.