PY

Basic Overview

Description	Shifts the input node Node one year into the future while retaining all other dimensions.
Signature	PY(Node)
Parameters	Node: Input node that is shifted, specified using the node name in single quotes (e.g. 'Profit')

Example

Input Profit

Year	Profit
2018	35
2019	42
2020	47

Output PY('Profit')

Year	Profit
2019	35
2020	42
2021	47

Example 2

SHIFT or Nested PY expressions can be used to move Nodes further into the future.

Input Profit

Year	Profit
2018	38
2019	45
2020	52

Output PY(PY('Profit'))

Year	Profit
2020	38
2021	45
2022	52

Difference between YOY_REL(), YOY_ABS(), and RATIO(PY())

When aiming to compare values across time periods, there are three very similar ways to do so. At the first look, they appear to function in the same way; they do however possess small but important differences that can lead to vastly different results. For more information please refer to Difference between YOY_REL(), YOY_ABS(), and RATIO(PY())