1 Reply Latest reply: Aug 4, 2016 10:04 AM by rodrigo silva RSS

    Returnee

    Omotayo Olokede

      Hello Guys,

       

      i have a bottle neck one of my report.. i have a list that shows my Shopping Customers and Created Customers which i am fetching from my Database... But i want to use this to generates a report that will show me list of RETURNEE Customers (i.e customers that are old and comes by to shop at a particular period of time.)

       

      Here is my Script:

      if (CUST_CREATED_DATE < CUST_LAST_SALES_DATE, Count(Distinct CUST_ID))

      e.g my created Customer for July after filter is 212 and Shopping Customers is 538, i need a report that will show that 538 - 212 = 326

      326 is my RETURNEE customers

       

      bu it Seems not to Work...

       

      Any Help Please.