this is the other workaround, the "Other Prices" field shows all the price levels in columns you can then export and filter in Excel. https://suiteanswers.custhelp.com/app/answers/detail/a_id/36862/loc/en_US

Here's what I did, for anyone interested: • Created a search using my normal criteria to find web items • Under the search criteria, under the Summary tab, I added a row where the Summary Type is "Maximum", the field is Formula (Numeric). I set the formula value to be equal to 0 and used the following formula:

CASE WHEN {pricing.pricelevel} = 'Pro Purchase Program' AND {pricing.currency} = 'USA' THEN {pricing.unitprice} ELSE 0 END

• Clicked "Use Expressions" and duplicated the row, adding an "Or" criteria with the following formula to also account for Canadian pricing:

CASE WHEN {pricing.pricelevel} = 'Pro Purchase Program' AND {pricing.currency} = 'Canadian Dollar' THEN {pricing.unitprice} ELSE 0 END

• Under the results tab, I used the same formula(s) to create columns for the US and Canadian pricing, using Formula (Currency) this time and a Summary Type of "Maximum", with "Group" as the Summary Type for my other columns ◦ As it turns out, the Summary type is important and is where I was getting stuck because it isn't specifically mentioned in the link above but if you don't put it in, you get a row for each price level. • Created an email alert for this search so that I can be proactively alerted whenever there are items that appear on the web that don't have pro pricing