Recent content by tsakdim

First of all, many thanks for your post. I tried it but the average of Out of Stock remains the same either I choose count of products or not either I choose max of call date or not. Could you share with me your querry in case I made something wrong? Thanks again. Dimitris

Hi Cronk, I attach the table. Thanks, Dimitris

Thanks for your reply! I attach a sample of our report. Regarding the Out of Stock indication, we use one column that says "Y"(es) for the out of stock and "N"(o) for the available items. We replace the "Y" with 1 and the "N" with 0 and we want to get the average as percentage with 2 decimal...

Hi Experts, we have a huge report in our company that includes all our customers, all the visits done by our sales reps, all the products they have and if a product was out of stock in the visit or not. I want to create a querry that exports a table with 3 columns: 1-->customer 2-->date of...