I have two tables left joined to get the list of expired products and the renewed products.
Basically i am trying to get the conversion %.I have created two sheets one with the parameter to start and end expiry date and other sheet with renewal date as parameter.
I have created a formula % conversion as sum(quantity)/count(expired) in the third sheet.When i apply the expiry date filter and renewal data filter on that %conversion sheet.it shows as 100% which is incorrect.
I am sorry as i couldnt attach the sheet as it contains some senstive information as i have joined those two tables on the product serial key .Could you please advise me if i am doing in the incorrect way.
You don't have to share the original data. You can mock up some dummy data which has same format as per your original data then
modify the values and send. Without seeing your data we can not give you proper solution.