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!

d_a_v_i_d Rookie Asked on August 17, 2021 in Saved Searches.
Add Comment
3 Answers

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?

Rookie Answered on August 17, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.