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.