2 Replies Latest reply on Apr 10, 2017 4:25 AM by Tarun Sharma

    Showing only the number of customers who has reported sales during the 50% of time for the selected time window

    Tarun Sharma

      Hi

       

      I have a problem where I only need to display the number of customers for each region who has reported sales during the 50% of time for the selected time range.

      Progress so far :

      • I have created two input parameters start and end date which will accept the date.
      • Using date diff function to calculate the diff between dates in month.
      • Now lets say we have 10 month of difference then I only need to show the customers which have reported more than 50% of time the sales (i.e. more than 5 months in this case.)
      • Need to show the sum of those customers for each region

       

      Thanks