Scripted fields: Coalesce


i want to write a scripted fields that do the following calculation. how should i do it.

Procuser = coalesce (ProcUserExpanded, ProcUser)

@ITchandj I don't know what version you are using but please note that scripted fields are being deprecated (as of version 7.13) and you should rather use runtime fields.

The docs explain using both well.

There's a great tutorial on scripted fields in the docs too.