RE: Help with HTML formatting in saved search result
Hi everyone. I am having difficulty getting this search to run with conditional HTML formatting in the results. I keep running into either the page returning a “An unexpected error occurred…” error or the search column returning “Error: Invalid Expression”.
CASE WHEN {locationnohierarchy} = ‘My Location’
AND SUM(CASE WHEN TO_CHAR({trandate},’MON’) = ‘JUL’ THEN {amount} ELSE NULL END)
BETWEEN .97 * 1836674.72 AND 1.03 * 1836674.72
THEN ‘<b><span style=”color:#ADFF2F;”>’ || SUM(CASE WHEN TO_CHAR({trandate},’MON’) = ‘JUL’ THEN {amount} ELSE NULL END) || </span></b>’
ELSE NULL
END
Any help is appreciated, thanks!
Good catch, but unfortunately still the same error. I believe you are right though, the SUM function seems to be causing the issue. Any idea how to sum transaction line amounts by location and incorporating HTML formatting using a formula text?