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.
Is there a way to achieve this highlighting? All I can see is highlighting based on a static value, not based on another field in the Search. I also cannot use the workaround of subtracting one from the other, since the 2 fields are different summary types and the subtraction is done on each search result before the summarization.
Any and all suggestions are appreciated.