I am getting an invalid expression on a custom percent field | Suitebuilder

Channels

Title

#suitebuilder

Cr223309

02/21/2020, 5:33 PM

I am getting an invalid expression on a custom percent field with this formula. Any suggestions CASE WHEN (({custbody17}-{custbody_mnt_tot_cost_so})/{custbody17} < 0.0) THEN '<div style="; background-color:yellow; color:black;font-weight:bold">' ||{custbody17}-{custbody_mnt_tot_cost_so}/{custbody17}|| '</div>'ELSE'<div style="background-color:red; color:white;font-weight:bold">' || '10' || '</div>'END

View count: 1

Join thread in Slack