I am doing an inventory search so I can export dat...
# general
j
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
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
Thank you, this was what I was thinking of too
I actually found these under "Other Prices". It is a single results field that brings both prices in separate columns.