case when {item.custitem_type_item} = 'Main Unit' AND MAX({rate}) then {item.displayname} end
I am doing a saved search and I need to fetch the name of the main unit. Which would be the item whose unit value is the largest. the conditions that must be met are that the item type is equal to 'Main Unit' and is the one with the highest unit value.