I have 2 data sources both with orders and dates. I need to check if dates from source 1 is earlier than from source 2 for the same order and count how many fulfill this condition. So I created calculated field which gives me 1 if it is true and 0 if it is false. And then I wanted to sum these 1 to get number of orders with earlier date in source 1. But as you can see in attached file - it does not work, because it shows Total = 0 while actually it is 3. If I open Summary it gives correct values - sum = 3. Why Total = 0, and how can I get information about how many orders have date 1 earlier than date 2?
4 answers
