Default Value in Initial Expression to Null ...

Buglouse
Participant IV

Default Value in Initial Expression to Null

I evaluate my initial expressions to “” when I want the field to be empty. For number columns this sets the value to 0, is there an expression upon evaluation that clears the value, not setting to 0 but to null or the empty value before the expression is evaluated?

1 2 2,602
2 REPLIES 2

@Buglouse

You can use NUMBER("") expression

ANY(LIST()) would also work.

Or instead of using an IF() expression, you could use an IFS() expression.

Top Labels in this Space