Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Formula(HTML) can't subtract variables
Hi,
I am really puzzled on this issue. I have a saved search that uses formula(HTML). Here is the snippet of code that doesn't seem to work as I would think. This a progress bar that gets a different color based on the value.
<progress style="
'||CASE WHEN {custentity_dhi_avg_mfg_lead_time} <= {custentity_dhi_mfg_lead_time}*1.1
THEN 'accent-color:green;'
WHEN {custentity_dhi_avg_mfg_lead_time} < {custentity_dhi_mfg_lead_time}*1.2
THEN 'accent-color:orange;'
ELSE 'accent-color:red;'
END||' float:right" value="'||{avg_mfg_lead_time}-{stated_mfg_lead_time}||'" max="'||{stated_mfg_lead_time}||'">
Tagged:
0