Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to 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)