anyone know how to hardcode values in saved searches...my formula is
CASE WHEN {type}='Bill' THEN 'PAYABLES' ELSE 0 END
need to replace type = Bill with the word PAYABLES
j
Joseph Lee
11/03/2022, 6:42 PM
CASE WHEN {type}='Bill' THEN 'PAYABLES' ELSE '0' END