Hello, does anyone know on how to escape or include apostrophe on a formula text? It returns an invalid expression if formula contains that character. See sample below. SUM(CASE WHEN {name}="Prince's" THEN NVL2({debitamount},{debitamount},0) ELSE 0 END) -SUM(CASE WHEN {name}="Prince's" THEN NVL2({creditamount},{creditamount},0) ELSE 0 END)

Try

WHEN {name}='Prince''s'

@michoel thanks much, it works...