$map(field,test?a:b)

$map(field,test?a:b)—If the field matches test, returns a; otherwise returns b. A null test matches a null field value. If b is null, it means field.

For example, if the value of ${makebuy} is “MAKE”, the following expression returns the value of ${make lead time}; otherwise, it returns the value of ${buy lead time}:

$map(${makebuy},MAKE?${make lead time}:${buy lead time})

If the value of ${territory} is null, the following expression returns the value of ${region}; otherwise, it returns the value of ${territory}.

$map(${territory},?${region}:)

Note: The $coalesce() function is more efficient when looking for non-nulls.