Jump to content

Purchase Price Discount by text Input


This topic is 7548 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi all,

I've got a 50,000+ products catalogue coming from more than 50 suppliers (manufacturers and wholesalers).

I need to calculate my purchase price based on a text input, which is given by the Vendor to express the discounts (in%) from the list price. This discount varies :

- from vendors to vendors,

- from collection to collection

- from reference to reference.

It also can change according to the quantity purchased.

Our best discounts might be expressed as :

50+10+10

and 50+10+10+5 if we happen to purchase a whole pallet for this vendor.

When building the solution, I never thought this way of presenting discount would have lapsed so long, but it seems vendors will keep taking us for some fools with these "expressions", considering the longer the "calc" is, the better the sales might be.

As a matter of fact 50+10+10 could also be expressed as 55+5, but I have rebates going up to 30+20+10+10+10+5 !!!!!

So given a price of 25$, 50+10+10 would be 25*.5*.9*.9 = 10.125$

How ?

Thanks.

Link to comment
Share on other sites

Neat one !

I was going

Number * ((100-MiddleWords(discount,1,1))*.01) * ((100-MiddleWords(discount,2,1))*.01) *((100-MiddleWords(discount,3,1))*.01) *((100-MiddleWords(discount,4,1))*.01) *((100-MiddleWords(discount,5,1))*.01) *((100-MiddleWords(discount,6,1))*.01)

Yours is surely cleaner...

Thanks

Link to comment
Share on other sites

This topic is 7548 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.