Discussions
In a Summary Saved Search, is it possible to Highlight comparing a Sum field with a Max field?
We have a Saved Item Search to calculate the inventory sell value for inventory in a given project. We achieve this by grouping on the Related Project custom field, and we Sum the {quantityavailable}*{price} to get the total inventory sell value. We also have an Inventory Cap on each Project record, so the search joins that field, and the summary displays it as a Maximum (since it is the same for all items in a given project, obviously).
We want to have highlighting based on comparing the Sum of {quantityavailable}*{price} with the Inventory Cap on the Project (Maximum of Related Project : Inventory Cap). Specifically, we want the line to highlight in yellow if the Inventory Sell Value is 80% or more of the Inventory Cap, and in red if over the Inventory Cap.
Pierre J.-L. Plourde
IT Manager/NetSuite Administrator
Peak Performance Products Inc.
e: pierre@pppinc.ca
t: 416-674-7325 ext. 1029
c: 905-439-7645
f: 416-674-7326
w: www.pppinc.ca
6956 Columbus Road, Mississauga, Ontario L5T 2G1
Oracle NetSuite Certified—ERP Consultant
Oracle NetSuite Certified—SuiteCloud Developer II
Oracle NetSuite Certified—Administrator
Oracle NetSuite Certified—SuiteFoundation
Oracle NetSuite Certified—Financial User
Oracle NetSuite Certified—SutieAnalytics User