Getting an invalid expression in my WF condition >...
# suiteflow
m
Getting an invalid expression in my WF condition > formula. How should this be written?
n
Have you tried wrapping the fields in NVL? like so: CASE WHEN NVL({balance},0) + NVL({unbilledorders},0) > NLV({creditlimit},0) THEN 'TRUE' ELSE 'FALSE' END
p
Are all those fields the same data type? Maybe also try a to_nunber() for comparison
👍 1
m
they are all string data type and i tried both suggestions (thanks) but still get the invalid expression error