Basic Overview

Please note that FALSE will only return a 0 for every defined row in the input. If you need a 0 for each undefined row, look at the IS_NA function, and invert its result with FALSE.


Description

Returns false (0) for every defined value in the input.

Signature

FALSE(Node)

Parameters

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

Example

DecimalNode =


Year

Revenue

2018

-24.5

2019

95

2020

110


Output FALSE('DecimalNode') =


Year

Revenue

2018

0

2019

0

2020

0


Products =


Year

Product

Revenue

2018

A

67

2019

B

85

2020

A

954

2020

B

-54


Output FALSE('DecimalNode'+'Products') =


Year

Revenue

2018

0

2019

0

2020

0


A=


Year

Revenue

2018

95

2019


2020

236


Output FALSE('A') =


Year

Revenue

2018

0

2019


2020

0