SIGNUM

Description

Extracts the sign of a number. Positive numbers become 1, negative -1 and zero remains 0.

Syntax SIGNUM(Node)
Parameter
  • Node: Input node, specified using the node name in single quotes (e.g. 'Profit')
Example

Input A =

Year

Product

Value

2019 Car -1
2019 Truck 3
2020 Car 0
2020 Truck -8561451155
2023 Car 65452141023


Output SIGNUM('A') =

Year

Product

Value

2019 Car -1
2019 Truck 1
2020 Car 0
2020 Truck -1
2023 Car 1

Was this helpful?

Yes | Somewhat | No