Scenario: When the tax total value is less than 1, the custom field designed to store the tax total in words displays an invalid expression. Solution: CASE WHEN {taxtotal} = 0 THEN ‘ZERO ONLY’ WHEN {taxtotal} < 1 THEN (CASE WHEN ROUND({taxtotal} * 100, 0) > 0 THEN TO_CHAR(TO_DATE(ROUND({taxtotal} * 100, 0), ‘J’), ‘JSP’) ||… Continue reading Invalid expression: Error on field created for storing the tax total in words