Coalesce
Returns the first of its inputs that actually has a value, skipping any that are blank. It is the clean way to say "use the real number if we have it, otherwise fall back" without building a chain of If nodes.
Inputs
| Input | Accepts | Required |
|---|---|---|
Value1 | Any | Yes |
Value2 | Any | Yes |
Value3 | Any | Optional |
Value4 | Any | Optional |
Outputs
| Output | Produces |
|---|---|
Result | Any |
Example
Mid-quarter, Q3 actual revenue does not exist yet. Connect the actual (blank until the books close) to Value1, the current forecast to Value2, and the original budget to Value3. The model always works with the best number available, and the moment actuals land they take over automatically.