Hi there,
I just the following code to format our {locationquantityavailable} to show colours.
CASE
WHEN {locationquantityavailable} > 10 THEN '<font color="#006400">'||{locationquantityavailable}||'</font>'
WHEN {locationquantityavailable} > 5 THEN '<font color="#EEB422"><b>'||{locationquantityavailable}||'</b></font>'
WHEN {locationquantityavailable} > 0 THEN '<font color="#BE2625"><b>'||{locationquantityavailable}||'</b></font>'
ELSE '<font color="#BE2625"><b>'||{locationquantityavailable}||'</b></font>'
END
It work like a charm, but I have to set the field type as "Formula (Text)" which make it align left instead of "Formula (Numeric)" align right. Result is like this screen: https://i.srsworks.com/i/92iP
When set it to "Formula (Numeric)" the search show "ERROR: Invalid Expression".
I set similar "Formula (Numeric)" for currency field with text without similar problem.
Furthermore, when export the list as csv, it export html code for the field instead of the number.
I'm looking for solution to resolve these issues or alternative solution if can't solved.
Thanks in advance.
Regards, kf