Hi All,

I was wondering if you were able to help, I have 4000 units to distribute across stores dependent on how many customers attended the store versus those who were invited, if this makes sense and I was wondering if anyone had a formula that will allow me to allocate depending on the percentage difference in the customer numbers as they will differ per store?

Many Thanks in Advance