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 the YOY_REL(), YOY_ABS(), and RATIO(PY()) page.
Contact
You may contact the Valsight Customer Support via:
