Expression Value Checking

Is there a more convenient way to check the value during the evaluation of the expression, other than if(result is ok, result, other)? Similar to Excel's ifError()?

COALESCE or TRY or both depending on your goal.

Here's a list of all expression functions.

4 Likes

I mean, there is an isError() experession function.

I guess it just depends on what you mean by "check the value".

2 Likes