1 Reply Latest reply on Oct 13, 2016 2:32 AM by Mahfooj Khan

    Percentage calculation Issue when join two tables



      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.