Hi guys, I was hoping someone might be able to assist me with a saved search I am doing. I am trying to compare vendor purchase price and then have it tell me which one listed is the preferred vendor. The problem is with my current formulas, when I run the results it only gives me the vendor price for which one is set to the preferred vendor. I want it to tell me the price that is listed for vendor 1 , vendor 2, and vendor 3, and then a column that says which is currently set as the preferred. Currently, it gives me a zero for the price for that vendor if it is not set as the preferred and only displays the preferred pricing.

I believe {vendor} is used for preferred vendors only. {othervendor} seems to be the non-preferred.

I'll give that a shot, thank you

What do you have in your criteria? If I do an item search with no criteria other than to filter on one item, and i show the vendor, vendor code, and price, I do see different vendors in the vendor column for each line

message has been deleted

Are you still running formulas in those results?

I'll give it a shot

the {vendor} != {othervendor} part of the formula is to identify those that aren't the preferred vendor.

Still not giving me both vendor prices when I did this:

I see, I had some differences in my saved search. case when {othervendor} = 'xxxx' then {vendorcost} else 0 end should display the cost. My original would only display the cost if the vendor was not the preferred. but looking at your results, you have a column to show the preferred, and my guess is you'll just reference the appropriate column to find the preferred price.

Ah ha! It worked!

Try the following summaries: Name: Group, Display Name: Group, COO: Group, Essendant Purchase Price: Maximum, Supplies Purchase Price: Maximum, SP Richards Purchase Price: Maximum, preferred vendor: group

That worked beautifully. Thank you so much for all your help Gregory.

So glad to hear! Happy to have helped!