Crystal report question - running total? Variable?
Posted on 2007-04-06
Crystal Report 8.5. I need a report that shows sales data based on customer join date and purchase activity. Let's say there are 2 tables one containing contact info and the other purchase history joined by contact_id. I need to show the count of contacts who made purchases within the first year of them becoming a customer, second year, third year etc. I tried using a running total using and evaluate using a formula that with a datediff calculation and the numbers does not look right.