AnsweredAssumed Answered

Count Related Records

Question asked by JorgeFernandez on Nov 6, 2012
Latest reply on Nov 7, 2012 by philmodjunk

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!

Outcomes