QOQ_REL

Basic Overview

Description	Returns the relative growth for each quarter compared to the previous quarter (quarter-over-quarter).
Syntax	QOQ_REL(Node <, MissingValueBehaviour>)
Parameter	Node: Input node, specified using the node name in single quotes (e.g. 'Profit') MissingValueBehaviour: how the function should treat missing values possible value are: IGNORE_MISSING (default) and MISSING_AS_ZERO

Input Profit =

Output QOQ_REL('Profit') = QOQ_REL('Profit', "IGNORE_MISSING")

Output QOQ_REL('Profit', "MISSING_AS_ZERO")

Quarter	Value
2019-Q2	(300 - 200) / 200 = 0.5
2019-Q3	150 / 300 = 0.5
2019-Q4	50 / 450 = 0.11
2020-Q1	(0 - 500) / 500 = -1
~~2020-Q2~~	(100 - 0) / 0 = division by zero results in entry not being present in result
2020-Q3	( 0 - 100) / 100 = 0