<@U3ZRPA8SX> you may try CASE WHEN statement
# suitescript
h
@jake you may try CASE WHEN statement