Hi, Guys, I have created a Item SaveSearch having item name internalid now i want to add formula field to get vendor purchase price with specific vendor and currency so i have added this formula but somehow it does not work

CASE WHEN {vendor.internalid} = '15035' THEN {vendor.cost}  ELSE 0.00 END

Try CASE WHEN {vendor.id} = '15035' THEN {vendor.cost} ELSE 0.00 END

it looks good but my problem is i want this item save search to work like a LEFT JOIN if the vendor exist then show their price value with specific currency else show 0 but now it is showing multiple records

What type of record ?

I am creating item search to get vendor prices only for vendor XYZ and Currnecy USD sot it will be like this ItemInternalId Price 12345 3.25 12346 4.26

ok I understand but the vendor and vendor cost fields are on the item?

It looks good but not sure it will work or not