I have a custom field (Type: List; List: Items). I am trying to get the rate of a specific price level from the item in this field. It seems that NS groups them all together in their "other prices" search option. I cannot exclude price levels at the search's criteria level because I will need to see different price level rates based on an item's features. Any insight on how to get to it?

we probably need more info. The issue you have is that prices are in a sub-table from the item and your fields have to hop across the join, which it can't dynamically. I solved a similar problem in a search by adding a formula making decisions based on the Price Level. I'll include some examples below which might help you.:

CASE WHEN {taxschedule} = 'Australia GST' THEN 1.1 ELSE 1 END* CASE  WHEN {pricing.pricelevel} = 'Retail'  THEN  {pricing.unitprice} END

CASE  when {pricing.pricelevel} = 'W'  THEN  {pricing.unitprice} end

Yeah, the issue is that I would need to be more like {customfield.pricing.pricelevel} and that's too many joins back. However, when I'm getting this information from a script, I can get to the prices via search with field names like "price2" and "price3" which is why I was hoping I was missing something with a UI Saved Search. No combination of anything involving "price2" or "price_2_" was working. I ended up putting the values on the item record outside of the price level to get this project moving along for now. Thanks for your response.

that's a common fix. did you include a little update script for keeping them updated?

Not yet. That's tagged onto the end of the project (when I'm no longer needing to give status updates). Luckily the prices are contractually locked in for a year before they're re-evaluated.

You could consider looking at an Analytics SuiteQL API to get deeper joins