understand what you are saying and I will be creating that column the only problem with that and I haven't tried your suggestion out today but it seems like it will discount whatever is a certain type. Meaning if I have 23 of item1 and 5 of item2 and it is set to discount of volume of more than 25 then all of it will be discounted. But it should only discount item1 if it's 25 or more and not item2 even though they are the same type. Thanks for your quick replies today.