Can NVL and NVL2 function only return numbers as the 2nd and 3rd expression? I'm trying to do NVL({quantitycommitted},'none committed') in a Saved Search Formula(text) but it results to an expression error. But if I use a number instead of a 'text' it works.

You might have to wrap your formula in a to_char

that did it thanks