2 Replies Latest reply on Nov 7, 2012 7:01 AM by philmodjunk

    Count Related Records

    JorgeFernandez

      Title

      Count Related Records

      Post

           Hi there!

           I´m trying to get some statistics with some relations:

           1. Need to count related records from a table:

                Main::FirstDayOfMonth = Stats::FirstDayOfMonth

                And I need to get the count from the related records (number of records created on a month)

           2. Need to count "total of non empty fields" on a related table, I use this to know the profession of my client, and have a field for each profession

                RelatedInfo::Lawyer X Stats2::Lawyer

                What I need to know is how many of my clients are lawyers, engineers, etc.

                Of course I have some fields on RelatedInfo::Lawyer on blank and some with the word lawyer.

            

           I appreciate your help!