Connects two inputs with the logical 'exclusive or' and returns true (1) if exactly one of the input values is true and false (0) otherwise.
Syntax
XOR('Node1', ‘Node2’)
Parameter
Node: Input node, specified using the node name in single quotes (e.g. 'Profit')
Limitations
Both nodes need to have the same dimensionality, otherwise they will be excluded from the function output.
Example
Input A =
Year
Value
2019
17
2020
0
2021
0
2022
1
Input B =
Year
Value
2019
1
2020
0
2021
1500
2022
0
Output XOR('A','B') =
Year
Value
2019
0
2020
0
2021
1
2022
1
Limitations
Both input nodes must contain the same levels, otherwise, the function will consider only the more granular function while ignoring the function with fewer levels.
Example of the limitation: The function is given two EXPANDSINGLE() inputs. However, one of the EXPANDSINGLE() functions possesses more levels than the other, resulting in different granularity. The function with more levels is the leading function. This leads to unexpected outputs from the XOR() function.
Contact
You may contact the Valsight Customer Support via: