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!
Saved Search: Highlighting with Summary type Results
HI, is there a way to highlight rows in saved search when 2 columns does not match?
The results are all in Summary type. For Example:
This row should be highlighted because Firewalls Equip Tab is not matched with Firewalls invoice.
The formula to pull the results for the 2 columns:
Summary Type= Maximum , Formula: CASE {custrecord_eym_ir_equipment_parent.custrecord_eym_ir_equipment_type} WHEN 'Firewall (No HA)' THEN 1 WHEN 'Firewall (HA)' THEN 2 ELSE 0 END
Summary Type= Sum, Formula: MAX(Case when {transaction.item} like '%Cybersecurity%' AND {transaction.item} NOT LIKE '%Switches%' then {transaction.quantity} else 0 END)
0