andrewpearce
New Member
Hi all,
Working with some raw scan data & for each SKU I want to assign the price break it falls into.
Price Breaks are standardised: $0-5 | $5-8 | $8-11 | $11-14 | $14-19 | $19-35 | $35+
I have a column that shows average sell price for each SKU & I want to use this to determine which price break the SKU falls into & then show the price break in a helper column?
Many thanks
AP
Working with some raw scan data & for each SKU I want to assign the price break it falls into.
Price Breaks are standardised: $0-5 | $5-8 | $8-11 | $11-14 | $14-19 | $19-35 | $35+
I have a column that shows average sell price for each SKU & I want to use this to determine which price break the SKU falls into & then show the price break in a helper column?
Many thanks
AP