I am doing an inventory search so I can export data. I cannot find "End User" pricing. Anyone know what the saved search would call this? If I use Pricing: Unit Price it will pull both Dealer Price and End User Price and duplicate my lines.
k
Kyle Tran
03/16/2023, 8:29 PM
You would need to use a formula to achieve that. I would use the "Formula (Currency)" with a formula like this: "case when {pricing.pricelevel} = 'End User' then {pricing.unitprice} end"
j
Jacob Burke
03/16/2023, 10:40 PM
Thank you, this was what I was thinking of too
Jacob Burke
03/17/2023, 3:06 PM
I actually found these under "Other Prices". It is a single results field that brings both prices in separate columns.