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
pmendola
02/20/2020, 10:16 AM
Are all those fields the same data type? Maybe also try a to_nunber() for comparison
👍 1
m
mg2017
02/20/2020, 3:09 PM
they are all string data type and i tried both suggestions (thanks) but still get the invalid expression error