How Does Decisions V8 Handle Null Values in Mathematical Operations? (Evaluate Expression Step)
in Flows
Hi all,
I noticed that in previous versions of Decisions, null values in mathematical operations were treated as zero. Has this behavior changed after Decisions V8? Specifically, how does the Evaluate Expression step handle null values during calculations?
For example, what happens if I add or multiply a number with a null value?
Thanks in advance for your help!
0
Comments
-
Hello,
Great question! In Decisions (V8 and the current release at the time of writing), the Evaluate Expression step uses an external library that treats any calculation containing a NULL value as NULL.
However, the platform then automatically converts this NULL result to 0 for display purposes. This is a change from earlier versions (Prior to V8), where NULL was directly treated as zero in calculations.
Examples in V8:
- If A = 1 and C = NULL:
- A + C = 0
- A / C = 0
- A * C = 0
- A - C = 0
- A + (B + C) = 0 (if B = 1, C = NULL)
Documentation for Reference:
0
Howdy, Stranger!