why does the vendor price in saved search show approximated

AI generated answer (using internal Slack threads):

The vendor price in a saved search might show as approximated due to the way the search is set up. If the search is set to only display the preferred vendor's price, it will not show the actual price for other vendors. This is because the

{vendor}

field is used for preferred vendors only, while

{othervendor}

is used for non-preferred vendors. If you want to display the actual vendor price for each vendor, not just the preferred one, you need to adjust your search criteria and formulas. One way to do this is to use a case statement in your formula to differentiate between preferred and non-preferred vendors. For example, you could use something like this:

case when {othervendor} = 'xxxx' then {vendorcost} else 0 end

, where 'xxxx' can be replaced with the vendor that your column is referring to. To display all the information on the same line, you can try grouping the results. For example, you could set the following summaries: Name: Group, Display Name: Group, COO: Group, Vendor1 Purchase Price: Maximum, Vendor2 Purchase Price: Maximum, Vendor3 Purchase Price: Maximum, preferred vendor: group. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******