2 Replies Latest reply: Jun 25, 2013 12:37 PM by Javier Florez RSS

    Error in count registers

      Hi. please help me with this problem. I have this organization.

       

      Manager

         Seller 1

            Customer 1.1

               Order 1.1.1

               Order 1.1.2

               Order 1.1.n

            Customer 1.2

               Order 1.2.1

               Order 1.2.2

               Order 1.2.n

            Customer 1.n

               Order 1.n.1

               Order 1.n.2

               Order 1.n.n

         Seller 2

            Customer 2.1

               Order 2.1.1

               Order 2.1.2

               Order 2.1.n

            Customer 2.2

               Order 2.2.1

               Order 2.2.2

               Order 2.2.n

            Customer 2.n

               Order 2.n.1

               Order 2.n.2

               Order 2.n.n

         Seller n

            Customer n.1

               Order n.1.1

               Order n.1.2

               Order n.1.n

            Customer n.2

               Order n.2.1

               Order n.2.2

               Order n.2.n

            Customer n.n

               Order n.n.1

               Order n.n.2

               Order n.n.n

       

      Each Customer has data for State, City and a CustomerCode too.

       

      The CUSTOMERS have (1 to n) orders, if the time in days between the last 2 orders in greater than 15 days, I must count the Customer (called Recovered). The format output format must be:

       

      Manager - Seller - State - City - Recovered

       

      But Recovered don't works, only works when I use this output format:

       

      Manager - Seller - State - City - CustomerCode - Recovered

       

      Please check the attachment.

       

      Thanks for your help.